I have an excel file that had a different tab for every month of the year, as well as a YTD tab. On each of those tabs is the names of our sales people and the details of the deals that they sold below each person's name. Every month I have to go grab all details for each person and compile them in the YTD. Sometimes things change in different months, so I have to go through EVERY monthly tab to copy the data for EACH sales person and aggregate it on the YTD tab. I'm trying to write a macro that will automate this process.
I have attached a sample document.
Thank you in advance!