Looping through worksheets, columns and rows

I have rainfall data going back 17 years,
with one year per worksheet, labelled with "year",
one month per column, labelled with "Month"
one day per row, labelled with day-number (empty if invalid day).

I want to do some analysis looking at consecutive runs of days,
so the current layout is not helpful.
I think I want to convert the data to (17*12*31) x 2: year-month-day, rainfall

I don't need the complete working solution, just a hint on the best way to go.
(preferably not with VB)

http://www.excelforum.com/the-water-...-question.html

Convert the dates in one column so that you have Year, Month, and Day as real dates. Do this for every worksheet. Then use the Pivot Table wizard, Choose Multiple Consolidation Ranges to compile your data into one Pivot Table.

Having done that you can now group by year, month or day or even number of days to produce various reports.

Another approach would be to combine all your worksheets into one worksheet and convert your dates to real dates then create a Pivot Table and group by date the Years, Months and Days as required.

Reading your post #4.

You are on an excel forum.

The data are not stored in an excel file?