Well, you can do this with lots of gyrations, but it is tedious and
error-prone. You are far better off logging this data in a single sheet laid
out in some manner such as

Col 1 Date
Col 2 Server
Col 3 User
Col 4 Data value

With data stored in this layout you can EASILY analyze it, filter and sort
it, create pivot tables & pivot charts, etc.



"my" wrote:

I have the following similar data in multiple sheets, say sheets 2 through
33, each sheet for each day:

Sheet2:
A B C D E
James Helen Bob Kathy Cindy
Server1 0.25 0.14 0.22 0.42 0.33
Server2 0.22 0.11 0.38 0.29 0.38
Server3 0.48 0.22 0.33 0.28 0.94
.
.
.
Server282 0.22 0.22 0.32 0.38 0.93

Sheet3:
A B C D E
James Helen Bob Kathy Cindy
Server1 0.25 0.14 0.22 0.42 0.33
Server2 0.22 0.11 0.38 0.29 0.38
Server3 0.48 0.22 0.33 0.28 0.94




In Sheet 1 I would like to summarize all of James's data.

Look up James in Sheets 2 through 33, and retrieve the corresponding number
for each Server.

My result should look like the following in sheet 1:

Server1 0.25 0.25
Server2 0.22 0.22
Server3 0.48 0.48

any suggestions? thanks very much! :D