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