need some help

[Emoncada]

I have a spreadsheet that is used daily, and saved multiple times during a day, all as different names. It's a packing slip that items are entered with location, item, quantity, serial number etc... I currently have a spreadsheet that I run that pulls data from those files pulling certain cells. I would like to know if there is a way that as soon as he saves one that data is pulled into another spreadsheet automatically?

 

[Emoncada]

I currently have to copy and paste all the saved files as PS01 - PS100. So the spreadsheet I made looks for those files. I would like to know if there is a way that I can have it look into a folder and just pull data from all the excel files within that folder. Possible like a batch file or a macro?