I have 5 workbooks and I need to pull two select, completed sheets out of each of those 5 in order to combine those into a new workbook. From there I am going to use that new workbook to run a print macro I already have. It's just cumbersome to go into each of the 5 workbooks, select the necessary sheets save and create a pdf then combine the 5 separate files into one.
I have seen multiple examples of combining all the sheets from all the books into one book or sheet, but I haven't been able to find an old post that does what I need to get done.
Any help would be very much appreciated!
I have seen multiple examples of combining all the sheets from all the books into one book or sheet, but I haven't been able to find an old post that does what I need to get done.
Any help would be very much appreciated!