Copy from one workbook to another within multiple tabs

[Ben4481]

Hi All,

I have two workbooks, both of which have identical layouts and each has three worksheets.

Workbook1 is 2009 data plus the 4 previous years. Workbook2 is 2010 data plus the 4 previous years.

What I am trying to do is update Workbook2 with the information from Workbook1, so in Workbook2 I will retrieve the amounts from Workbook1 for years 2009, 2008, 2007, 2006. This needs to happen for each of the worksheets in turn.

I have attached example workbooks. My actual workbooks each contain 90+ worksheets so I ideally need code that doesn't restrict the number of worksheets.

The user will start with Workbook2 open. It would be great if the code could also include finding and opening Workbook1 which would have been saved the previous year.

Thanks in advance for any help!