Hello,

I am trying to create a weekly report that has automaticly updated
summary sheet. I have created a a data sheet with all 52 weeks, each
week looks like below. All of each week ending data ranges are named
with the week ending date. For example the range below is named
01/03/06.

Shipping Wean Rcv. PSR
Strain Male Female Male Female Male Female
A 60 710 347 690 17% 13%

B 103 1429 574 1326 18% 18%

C 10 200 192 416 5% 48%

D 0 210 111 162 0% 30%

E 0 168 39 93 0% 81%

F 0 10 53 85 0% 12%

G 0 0 40 43 0% 0%

H 0 0 17 36 0% 0%

I am trying to find a way to reference the whole data range for a given
week on the summary sheet. Basically I want to be able to type in the
the week ending date in a cell on the summary and have that data range
show up on the summary sheet in the range A5:G21.

Thanks