I have an issue ive been trying to figure this out for some time now. Basically I want excell to take data from any new file i have in a specified folder. So when a file is added i want excell to automatically recognize it then paste it into my main workbook. It would be ideal for the data to be placed in the same area so that the formulas for the worksheet will still tie in.