I need a way to get cell contents (the value) of a cell I click on to be used
in the calculation. I have reviewed formulas and did not see what I needed,
unless I missed it.

example would be a list of people and thier values from individual sheets.
I click on the employees "value", on the master sheet to show results.

I realize I could set up a sheet for each person, but I thougt this would be
easier.
John T
tcs at mvn.net