Check out the copy paste merge examples listed here...

http://www.rondebruin.nl/tips.htm
--
HTH...

Jim Thomlinson


"Excel newbie" wrote:

Hi,

I need help to create a macro/vba code that would consolidate
worksheets from different workbooks into one. All the worksheets being
consolidated have the same format. All the different worksbooks are
saved at the same location

For example under Y:DRIVE\REPORTS\ANALYSIS, the analysis folder will
have 4 or more workbooks with titles A, B, C, D, etc.. Each workbook
will have the 12 months Jan to Jul. If I want to consolidate all the
Month July worksheet into one workbook... how can I do this.

I have to do this everymonth consolidating each of the current months
worksheet. I just need to copy the individual worksheet/s into one
main for that month.

Thank you in advance for any assistance that you may provide.