TestWorksheetImportTo.xlsmTestimportfrom.xlsx


First of all - thank you all for helping me so much with my work and helping things be more efficient. It's very, very useful, and I've never seen a more helpful online community.

With that said, there are two links above. There's an importto xlsm, which is where I need to pull data to. Then there's an import from, which contains the data I want to import into the importto sheet.

What I want is to have a button on the importto sheet that opens up a file explorer. I then select a file, with the importfrom sheet as an example here, and it pulls the necessary data from that sheet and inserts it into the correct location. For the most part, it's all fairly intuitive. Though in a slightly different order, the headers are the same between the two.

Thank you all in advance!