Hi, desibabuji,

if you change the name of the worksheet to suit (from Master to Export_1104) and adjust the path to the folder accordingly, the macro from Jerry will import the contents of any wortkbook found in the location into the sheet. I would recommend a sorting on the data after the import and maybe run a search for duplicates on the data assembled. If you need help on that code I think JBeaucaire would be the best person to ask but maybe I can handle that (not as good as Jerry but anyhow make it work - somehow).

If you want the user to take care of which workbook to amend or copy to a new worksheet in the macro workbook please feel free to come back and ask - I could supply a code which lets the user choose the file and then ask via MsgBox whether to amend or insert into a new worksheet.

Ciao,
Holger