Pull information into separate tabs

I have a large workbook with a data sheet of approx. 600 employees. This sheet includes personal information and also the Emloyee's Supervisor.

I need to pull each supervisor's employees into a separate worksheet with that Supervisor's name only showing specific information.

I thought I could do it with Pivot Tables...but given the large number of Supervisors, this would make the file huge.

I don't want to use auto filter or anything because I'm using a Distribution Manager that sends a specified worksheet to each Supervisor.

How can I do this? I've tried using MS Query as well but when I send it out, some folks can't open the files.

If you haven't received any answers, consider why!

maybe an example workbook would make it easier to understand

This might help, it will create a worksheet for each unique item in column A and copy the details to the required sheet:

Please Login or Register  to view this content.

If you need help adapting it to your needs let me know.

Dom

Try this:

Please Login or Register  to view this content.

Dom

Here you go:

Please Login or Register  to view this content.

Dom