Thanks ahead of time for your help! This forum has been a life saver.

I have been recently tasked with a complex issue (for me that is )

There is 6 reports that I need to condense into 1

The report are broken out by REP NAME (which is consistent throughout all 6)

So my initial thought is to create an excel sheet that contains a tab for each rep

EX: BOB, TOM, JUDY

Then I would open report 1 of 6.

I am hoping there is a formula I could put in the "new spreadsheet (with tabs) that says, pull over any information that has (BOB) in column A, and move it over to the "new spreadsheet" tab "(BOB) row X


Any ideas?