propogating cells with data from numerous sheets

[G. Beard]

Here's a sample of sheet1 data that I've propogated from sheet2 through
sheet 10.


A B C D E F G
H I
1 TOTALS: 38 Sets in Progress 16,764 7,908 8,856 47.2%
2 Priority Year Set Info Set Total Have Need %
Complete Updated
3 LOW 1952 TOPPS 407 0 407 0.0%
4 LOW 1953 TOPPS 274 0 274 0.0%
5 LOW 1954 TOPPS 250 0 250 0.0%
6 LOW 1955 TOPPS 206 0 206 0.0%
7
8
9 HIGH 1997 TOPPS 495 494 1 99.8%
10 HIGH 1998 TOPPS 503 499 4 99.2%
11
12 HIGH 2000 TOPPS 478 476 2 99.6%
13
14
15 HIGH 2003 TOPPS 720 716 4 99.4%
16 HIGH 2004 TOPPS 732 667 65 91.1%
17
18 0 0 0 0 0
0 0.0%
19 0 0 0 0 0
0 0.0%
20 0 0 0 0 0
0 0.0%
21 0 0 0 0 0
0 0.0%



FORMULA IN CELL A4 IS:
=IF(SHEET2!$H4<1,TOPPS!A4,"")

The data on this sheet comes from sheet2 in this workbook. The blank
rows are from sheet2 rows whose column h equals 1 (actually 100%
complete).
I need to omit the blank rows on this sheet by having the formula pull
data from the next row if column h equals 1. The rows that contain all
zero's at the bottom of this sheet are from empty rows on sheet2 at the
end of the data range. I need those rows to be populated with data
from sheet3 and so on to the last sheet.
All subsequent sheets are in the same format as this sheet except
sheet2 and on do not have header rows 1 and 2 from this sheet.
Each sheet has data from different manufacturers. So, I want this
sheet populated from top to bottom with data from sheet2 thru
sheet10.


Thanks for any ideas,
Gary