Assuming:
1) The column to watch is column A on a specific sheet
2) The exact location of the file is known
3) The new copies go to a specific location
4) If the file already exists in the destination folder, it would NOT be overwritten with a new one should you enter the same number a second time.
The following macro is an event macro, it goes in the sheet module where you are typing these values. Right-click that tab and select VIEW CODE, paste macro into the module that appears. It will certainly needs some tweaking on your part:
Bookmarks