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

Nothing?.,.

I guess I didn't show that well. Basically from the PC file I need that data imported from specific cells to specific cells in the inventory workbook. I have multiple PC files so I need a way to change the target file and pull the same information again just in a new tab. Does that make sense?

Each "PC" file will have the data in the same cells that I need transferred to the "Main Workbook" however I need to transfer to specific cells in the workbook in one row then go down a row to insert the next PC information. Is that possible? I can code but I just need a basic template to follow.