Merge sheets

[naquer]

Hello

I have an excel workbook with around 100 different sheets, with the EXACT same layout.
Now, I have some cells that I picked out from every sheet in order to make a summery (F2 - O4 in the sheets)

I need to create a merge sheet that combines all the sheets in one. I created a sample to illustrate manually, but I figured that this would take an awful amount of time to do for 100 sheets.

Is there a smart way to merge this?

[jeffreybrown]

If you look here there is some pre-built code you can modify to your specific ranges.

http://www.rondebruin.nl/copy2.htm

[naquer]

Thanks alot.

I also have the exact same formula for F2-O4 in all sheets. Can I somehow make this on the first sheet and copy it on to the exact same destination on all existing sheets?