Search multiple excel files in several folders; find string; copy data to a single sheet

Title should also state that once a string is found I would like to copy and paste data from an adjacent cell.


I have 20+ folders, each with 20+ .xls files and I'd like to consolidate a subset of the data that is contained within each spreadsheet. There are UTM coordinates are within one cell of the label; 'northing', 'UTM (S)', 'UTM (N), 'easting' or some variation.

I would like to do this for several data values within the sheet, but I think I can figure it out if I can do the above task.

Thank you very much for looking, any help would be greatly appreciated.

Travis