or even worthwhile?

i have a summary sheet with sheet names representing people's names. so,
john, martha and so on.

then john and martha have separate workbooks in the same folder, named john
and martha.

so a formula in the summary sheet named Bob would be something like this:
N:\My Documents\Excel\Bob.xls'!Jan_Tot_Loan

would it be advantageous to have the bob.xls part generated from the
sheetname(Bob)? if so, what would the formula look like?

that way, if bill was hired, i have a blank sheet i can copy for bill to
enter his data, and then only have to add a sheet named bill, and copy all
the formulas from bob's sheet and they would just work because of the new
sheet name being bill?
now i do a search and replace for the name.

just wondering



--


Gary