How transfer data from one file to another other with VBA
 

My Excel (97 newer) application allows user to "Save As" any number of files
from the main program. When the main program is updated, however, the
existing saved files are not updated. So I would like to make it easy for
the user to auto-fill the main program with data entries made in any one
saved file. The cell numbers and ws names are consistent. Can anyone please
advise the best procedure. Thank you.

Jim Kobzeff