Macro to move to next worksheet and repeat task

Hi
I am new to Macro and would like some help. Thanks
I have recorded a macro to pick up data from various cells in a monthly report spreadsheet and return them to my annual spreadsheet.
The code does work on the first spreadsheet but I have 13 sheets to get the data from.
I figured there must be a way to have the macro go to the next spreadsheet and pick up the same cells and return them on to the next line.
So after the code has worked on sheet 1 I need to go to sheet 2 and sheet 3 etc and pick up data from the same cells and enter on the next available row (which would be 401, 402, 403 etc)in my annual spreadsheet
Any help would be appreciated.

Thanks very much

Please Login or Register  to view this content.

Originally Posted by davesexcel

Hello, and welcome to the forum,
Unfortunately,

[I]Your post does not comply with Rule..........

Hi Wakisme,
I did not see that you had edited the title, thanks.

Hi Wakisme,
Open the two attached workbooks and run the code from the Wakisme workbook.

It is a very simple example using just 3 cells on three sheets.