If you have something in Column A from which you would know the
sheetname for that employee (name or emp#).


F2: =IF($A2="","",INDIRECT($A2&"!"&B$14))

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"manager in training" <manager in wrote in message
...
I am trying to link my employees time and labor logs which they fill out on
the company computer to a master workbook which will show all there
information that they filed out. I am able to link one cell at a time, but
am unable to link a complete worksheet at one time.