Hi,

I thought you posed that you fixed the "Date" problem.
Let me know.

Also you need to make sure the "Vendors" file format is the same as the "template" format.
Otherwise the data in sheet1 will not populate correctly. Also as mentioned you need to make suer the "Template" sheet names and the same in the "Vendors" file. Make sure you adjust your code for this.