first copy data from each excel file and paste it to another file.

Hi everyone…

I have hundreds of PO(purchase order) in which everything has been mentioned but what I need from them are-
Firstly, Supplier Name and secondly, their Item codes with description. I am finding it very difficult to open every PO file and copy the cells value only and paste it to another file.


I have one excel file named “summery.xlsx” and want to copy the supplier name from PO which is in same cell (“P15”) in every PO. And then copy the “Item code” and “Description” following “Sl. No.” too. Again Supplier name from another PO file then its “Item Code” with “Description” and by so it would continue as long as all the files copied . I have given sample in attachments.

Note: I have all files (541) in alphabetically arranged in same folder.

Thanks in advance.