How to pull data from main worksheet into other pages in same book

[ESUCP Jamie]

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?

[Break_Point]

Hi ESUCP,

It sounds like you will need a vlookup formula or index & match formula to pull through the data per staff member.

Post a workbook if you need further help.

[FDibbins]

Welcome back ESUCP

As suggested, upload a sample workbook (no sensitive data), showing what you have, what you want, and how you arrived at that.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[ESUCP Jamie]

You lost me at "vlookup". So here's a sample, simplified workbook ...

Test book.xlsx

I want to maintain the master list, but also have individual pages for each staff member that stay up to date based on the information I add to or change on the master list.

If you need more, please let me know. I'm heading home shortly, but I'll be back tomorrow.

[FDibbins]

It might help if you provided a few samples of your expected outcome on a few staff sheets?

[ESUCP Jamie]

Test book 2.xlsx

Now with the staff member worksheets filled out as well!

[FDibbins]

On sheet1 Q3, copied down, use this...

=C3&COUNTIF($C$3:C3,C3)

T%hen on each sheet, use this, copied down and across...
=IFERROR(INDEX(Master!$A$2:$P$21,MATCH(MID(CELL("filename",A3),FIND("]",CELL("filename",A1))+1,256)&ROW($A1),Master!$Q$2:$Q$21,0),MATCH(A$1,Master!$A$2:$P$2,0)),"")