merging workbooks

[deanl33069]

How does one merge several work books each has 1-3 sheets into 1 large workbook while keeping the formating and VBA in tact?

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...ooks-sheets-another-workbook.html#post5307898

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).