I have one spreadsheet (Spreadsheet 1) that has 552 tabs. Every OTHER tab has data that I need moved to tab 1. The end result will be one spreadsheet with all of my data. I have been copying and pasting but I need you to do it or possibly a macro can be used.
After that spreadsheet is complete. I have a second spreadsheet with a list of contacts that I need to combine with Spreadsheet 1. The spreadsheets have the same contacts but Spreadsheet 2 has their contact information e Spreadsheet 1 has their sales data.