Loop through sheets - pick up formula from same cells each sheet into summary sheet

hi Webbo, welcome to Excelforum. As you have a specific question relating to your workbook and your data layout it would be helpful to provide sample workbook with 3-5 sheets representing weeks with original data layout. Change any sensitive information to something else preserving data format: numbers remain numbers, words remain words. It also helps to see the expected outcome as well for reference.

Hi watersev

Thanks for your reply. I've attached a workbook which, hopefully, shows what I'm trying to achieve. I've manually created the formulae for Weeks 1-3 in the "Summary" sheet (Rows 7,8 & 9), which pick up from sheets "01", "02" and "03" respectively. I need to replicate the formulae in Rows 7,8 & 9 in the Summary Sheet to pick up from Sheets 04 - 52 (not yet added).

Hopefully you may be able to point the way! I'm sure the VBA is very simple - I'm just so out of touch. (Even worse - my end user uses Open Office - so once I've run the macro, I have to ensure it works on his platform.)

Thanks and regards

Webbo