Import data into excel from another workbook

Hi Guys, I am in need of some assistance here. I've been searching for code, but haven't found exactly what I needed. Basically I have a large amount of excel documents that hold individual PC information in each one and each file is named after the PC. I need to be able to pull in each sheet and have the data copied into the excel sheet for inventory purposes. I would prefer if I could pull in each PC files information while having the PC data file closed and just using the file name to target the file. The inventory excel sheet will need to pull in the information into certain cells then go to the next tab so I can pull in the next document or something close to that.

I've attached examples.
The PC file was actually a .csv but it wouldn't upload so I saved it as an excel file.

Inventory Workbook.xlsx is the Inventory workbook all the files will need to be pulled into.

PC1234.xlsv is an example of a PC which needs to be pulled in.

There will be multiple PC "sheets" IE: PC1235, PC1233 etc..

Thanks for your assistance.
Ancient