Hello

I need some help to search multiple excel files.

In order to keep track of my inventory, I have separate excel files for each machine.
Each file contains description, part number, location, price, etc. Each category is under same column in all the files. i.r. part number is always column B.

There are 42 excel files. It is very time consuming to open each file and search for a part.
I am trying to find out how I can find a part by searching either part number or their description through multiple files.

I have considered importing all the files to Access and use Access features. However I am not well educated how to use Access.

I like to know if there is other wys to do this.

If it sounds vague what I am looking for, please let me know and I will explain more.

Thank you in advance.