I have a the following scernario. I have a tab with data that i need
summarized in another tab and some consolodation.

a b c d e

1 Data Data Data Data
2 Data Data Data Data
3
4
5 Data Data Data Data
6
7
8 Data Data Data Data


In the summary sheet i need rows in this example Rows 1,2,5,8 to be brough
over to the summary table.

1 Data Data Data Data
2 Data Data Data Data
5 Data Data Data Data
8 Data Data Data Data

The problem is, that this needs to be dynamic, i.e. no blanks, and will need
to grow, so the next time i may need a summary of all rows 1-8, or the data
may grow, and i'll need a summary of 1 - 30 (with sporadic ommisions)

I hope you all can help.

Thanks

Tim