We have a sales admin that downloads data from our system daily and then what she was doing was filtering by Engineer, then cutting and pasting in each individual tab the information associated with each specific ENG (takes her several hours to complete the entire process DAILY). I've linked the fields from the TOTAL tabs to all of the individual tabs with Engineer names. Is there a formula that can take the information associated with the specific assigned ENG (column K in TOTAL tab) and filter it out to the other tabs? They don't want them filtering from the main TOTAL tab. And the ENG said it's easier if they can just go their tab and look at their projects. I have a couple of other things I would like to do to the spreadsheet to make her job easier but I'm starting with this first. Once I complete this step, I will ask the other questions.