Help on consolidate worksheets from different workbooks into one


Excel newbie


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.




Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question