I am trying to put together something that will take a couple of manky spread sheets and combine them into one neat summary. The manky spread sheets are the result of a data export from a web-based program. As far as Excel is concerned, these spread sheets are in html.

I need a sub routine that selects the correct sheet so that it can be cleaned up. If I manually move the sheet into the workbook where I’ve got the subs a simple

For each spreadsheet in Sheets
If...

routine selects the right sheet, but I need a way of searching outside the work book, so that the user doesn’t need to move the spread sheets manually.

When the spread sheets are down-loaded their names are essentially random.

The sub routine needs to work in Excel 2003.