Hi:

I am consolidating data from multiple spreadsheets into one. I have
successfully done this for fixed cells from each of the individual
sheets.

I am having trouble doing this for another set of sheets where the
data that I want to consolidate is not similarly structured across the
sheets.

For example the row that the data starts on varies by sheet. So I am
wondering how can I set the starting cell/row and iterate through the
columns within that row to copy the data to a consolidated worksheet?

In each of the sheets I have a starting row, and how many rows of data
for that particular data.

Thanks,
Eric