macro to transfer cell data to summary sheet

[dtsphil]

I have multilple worksheets that I want to summarize into a summary sheet. The data I want to copy from the worksheets are in cells A2, B2 and C2. As I work through each work sheet, I want a macro to copy the info and place it into the summary sheet in cells A8, B8 and C8. Once I complete worksheet 1, I immediately use macro to transfer data. As I finish worksheet 2, I want to use the macro again to transfer the data again, this time to the cells below the first transfered data and so on and so on. Thanks for the assistance.

 

[bobsan42]

Do you really need a macro?
You can use INDIRECT function to achieve this for 3 cells. You will only need a list of sheet names. With the benefit that your summary data will always be up to date.

 

[dtsphil]

Do you really need a macro?
You can use INDIRECT function to achieve this for 3 cells. You will only need a list of sheet names. With the benefit that your summary data will always be up to date.

Thanks for the reply. I apologize for the delay, I haven't been on this site for a while. The information that I am summarizing is for a type of audit. I'll have a macro to copy a template worksheet to the amount that I require for the audit. I then need to transfer 6 cells of data from each of those worksheets to the summary sheet. I was going to create a macro and button, so when the worksheet is complete....press the button and the information is transferred to the summary. I am trying to create the macro so if cells A2:F2 are filled......the data from the worksheet will drop to A3:F3...and so on