I need help writing code for the following process:

I have a 'master' workbook consisting of 3 sheets; data, table and pie
chart. In addition I have multiple Excel workbooks, each with 'data'
for a different geography. These 'data' files have the identical
range; A1:Q18. The scenario is 50+ 'data' workbooks open, along with
the 'master' workbook containing the 'report' and 'pie chart'. The
'report' tab is linked to the 'data' sheet, while the 'pie chart' is
linked to the report. I'm trying to write a 'Do Until' macro that
begins with the first 'data' file, copies an exact range from it,
pastes the range onto the 'data' sheet in the 'master' workbook at cell
A1, renames the workbook based on a name in a specific cell of the new
'data'. Then 'saves and closes' the new workbook, and then repeats the
process with the next 'data' workbook.

My problem is once I rename the original 'master' workbook it's closed,
so my Do Until statement stops.

Does anyone have any ideas on how I can write code to make this work.

Thank you,

Tony