I am trying to compile data from multiple sheets (at the moment I have 10 sheets) into one sheet. Each sheet tracks calls made by one salesmen, and all of my salesmen have a different number of clients, so while each sheet has the same number of columns (client name, product, date, etc.), the number of rows (clients) varies. I have already given specific permissions for the salesmen to access their own sheet, but now I would like to figure out how to bring all the sheet data into one summary sheet automatically. I'd like to be able to sort the data at the same time, but I know that's probably not a possibility.
Also, on another note, can anyone refresh my memory on how to call a sheet name to a cell? I think I've done it before, but I can't find where/how I did it.
Thanks!
Bookmarks