I have an excel file with multiple sheets, each of which is unique to a specific sales rep and contain a list of their client contact info including company name, address, City, State and zip. There are 15 reps, hence 15 worksheets. I am trying to see if there is a way to consolidate all the contacts into one sheet called Summary. I know I can manually copy and past from each worksheet, but was hoping there was a better way, especially in light of the fact the reps add new contacts on a regular basis.
Attached is a sample that I cobbled together. I realize my current formula in the summary field is primitive and will not satisfy what I am looking to do.
Thanks!
Bookmarks