This has taken quite awhile to get working. Thanks for all the ideas and information. I have likely taken a long way around the issue but it is currently working. I've tried the 'file picker' direction but it doesn't seem to be available in this my version of Excel.

Each individual ATM location has it's own macro tied to a button on the combined worksheet. The date issue is handled by selecting the date on the worksheet, copy it to a neighboring cell and change the format from dd/mm/yyyy to dd.mm.yyyyy. Using DIM statements to identify the current day's workbook, then proceeding through the many steps to move data from the worksheet to the destination cells.

This has been 'fun' to learn. There are a few more things I can envision Excel being able to accomplish for me and I'm still working on those.

Again thank you to the forum for all the assistance. I'm sure I could not have done it without you.