How do I look up a name on a worksheet and if there, transfer all information in row to new tab

[good1]

I have a worksheet with all my information on the first tab. I'd like to create a formula where Excel would look for a supervisors name in the first tab and if there, pull that entire row and put it in that supervisor tab.

If that's possible I'd also like a way to only pull certain columns into the supervisor tab.
For example, if that supervisor only wants column A,D,E, G, and I, how do I make Excel do that?
I have Excel 2007
Thank you!

 

[xlstime]

Hey Good1,

I have used helper column for running count, hope it will help

I have a worksheet with all my information on the first tab. I'd like to create a formula where Excel would look for a supervisors name in the first tab and if there, pull that entire row and put it in that supervisor tab.

If that's possible I'd also like a way to only pull certain columns into the supervisor tab.
For example, if that supervisor only wants column A,D,E, G, and I, how do I make Excel do that?
I have Excel 2007
Thank you!