Combine 100s of workbooks into single workbook

[jamilm]

Hi All,
I am trying to write/find a vba to combine 25 of workbooks into single workbook (for each workbook a single worksheet in main single workbook)
and then i want next automation command to generate pivot tables for all of these worksheets in a sinlge workbook.

i would appreciate any comment and help.

best regards,

 

[hiker95]

jamilm,

See if this gets you started in the right direction:

WBs to 1 Sheet
By Jerry Beaucaires
https://sites.google.com/a/madrocke.../merge-functions/consolidate-wbs-to-one-sheet