I knew I'd be back, FDibbins.

So now I have a "master" spreadsheet listing a whole lot of clients.

One of the columns contains information about what staff member each client is assigned to.

I would like to pull data from the master worksheet into separate pages in the same workbook based on the name of the staff member in that column.

Each month when I add client status in a new column on the master page, I'd like the new information to automatically appear on the staff member pages as well. And I'd like everything to update automatically - that is, when I change a staff member name on the master sheet, I'd like that client's data to appear on the page for the "new" staff member.

I feel sure this must be possible, but none of the directions I have found online or in Excel Help quite get at what I'm trying to do.

Advice, please?