Creating a summary tab with varying data tabs

[shmoes]

Hi all,

I have an excel document which track employee, attendance, location, personal info, notes, updates etc etc

Each tab is an individual employee

I want to have the first tab be a summary of all the employees out in the field and select some specific fields to update on the summary page

Example - Employee Name, assigned location, work hours, days off. and link that name to the tab.

If it was static tabs or occasional updates, I could just easily add it manually.

The problem is the employees come and go with a high turn over, so I need to be able to see the current update quickly as to who's out there. so there might be 30 tabs today 15 next week 30 the week after.. etc..


the format for each individual employee page is the same..
I just don't know how I can refresh or auto populate a summary/list page.
Any help is appreciated

TIA

 

[steve the fish]

You need indirect. If the sheet name is named after the employee and the employee name appears EXACTLY the same on the summary sheet you can adapt like this where A1 contains the employee name (and sheet name).

=VLOOKUP(A1,INDIRECT("'"&A1&"'!"&"A1:B2"),2,0)