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.
[link] [comments]
Want to read more?
Check out the full article on the original site