Hello
I'm at a loss on how to merge together worksheets in my workbook where every worksheet has a different name.
My worksheet has the following tabs:
1) Instructions
2) Client Tracker
3) Client (1)
4) Client (2)
5) Client (3)
The Client Tracker spreadsheet is a blank template of the other client spreadsheeets. I need my code to go through the worksheets and if they're named Client (x) then copy it's contents (which are in a table format) to client tracker. I need it to do this for all the Client (x) worksheets so I'm left with the Client Tracker worksheet containing all the info from the Client tabs together in the (previously) blank table
I couldn't find anything similar on this thread elsewhere so apologies if this is repeating something
I'm at a loss on how to merge together worksheets in my workbook where every worksheet has a different name.
My worksheet has the following tabs:
1) Instructions
2) Client Tracker
3) Client (1)
4) Client (2)
5) Client (3)
The Client Tracker spreadsheet is a blank template of the other client spreadsheeets. I need my code to go through the worksheets and if they're named Client (x) then copy it's contents (which are in a table format) to client tracker. I need it to do this for all the Client (x) worksheets so I'm left with the Client Tracker worksheet containing all the info from the Client tabs together in the (previously) blank table
I couldn't find anything similar on this thread elsewhere so apologies if this is repeating something
