Below is a sample of data collect by shift and month. Below the double line
at the buttom you'll see a grouping of the average calculated against the
fourth column from left to right. What I'd like to know is if there is a
method using either functions or code which would scan the sheetname and grab
values from the fourth column and avarage them out based on month values in
the second column and avarage them out as in the final sample in the buttom
of this example. The sheet names are as follows: A Shift, B Shift, C Shift, D
Shift. The final example at the buttom sits on another sheet entirely and
feeds a chart which sits on the same sheet! Is this possible? If it is, how?
Thanks for looking at this problem. Any suggested solutions will be welcome!

A Shift:
A 5/29 Airwear 5384
A 5/30 Airwear 5280
A 5/31 Ovation 5379
==========
B Shift:
B 5/27 Airwear 5065
B 5/28 Airwear 5478
==========
A Shift:
A 6/3 Airwear 4488
A 6/4 Ovation 4553
A 6/8 Ovation 4960
A 6/9 Airwear(C) 4980
A 6/12 Airwear 4037
A 6/13 Airwear 3684
A 6/14 Airwear 1954
A 6/17 Airwear 4869
A 6/18 Airwear 1089
A 6/22 Airwear 4170
==========
B Shift:
B 6/1 Ovation 5571
B 6/2 Comfort 3949
B 6/5 Ovation 5198
B 6/6 Ovation 5038
B 6/7 Ovation 4286
B 6/10 Panamic 5689
==========
==========
PPT Chart Sheet
May 04 Jun 04 Jul 04
Shift A 5,348 4,272 4,724
Shift B 5,272 4,588 4,426
Shift C 5,054 4,784 4,571
Shift D 5,396 5,059 5,164