Vba code to compile specific details from different excel file to one file from folder

Hello experts,

There are around 300 excel files and kept on my desktop on specific folder all 300 excel file having Proforma Invoice sheet, from these Proforma Invoice sheet i want to pull specific information to this excel file in sheet1.In sheet1 in column A i want Cell A10 value and In column B i want Cell A18 value and in Column C
I want Cell E12 value and in column D i want Cell G46 value from all 300 excel files.

Please find the attached file where i need data from different files

Regards,
upa