2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Looking for a way to combine all similar sheets from different workbooks into 1 new Book

we have a few customers who are ordering goods from us and different departments will basically get the same digital order form to fill out what they want. We have it set up so we have different garments types on different sheets with formulas and links to keep things organized for customization(in case certain customers want their names on certain goods.

I'm trying to figure a way to consolidate the same sheets from different workbooks together to create one master order form for out production staff.

for example, all of our workbooks will have sheets that for garments like sweatshirts, work shirts, overalls, work pants, jackets, etc. I would like to be able to grab all the sheets that say work shirts and copy them all into 1 book.

I looked into using a power query but the imported data doesn't visually look the same as the the original document. I'd like to have it remain the same.

I've been manually copying each sheets into a new document and while it does the job, it's very tedious to do when a customer has 20+ departments to do.

submitted by /u/the0utc4st
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article