I have a SharePoint Server that has a list with multiple SharePoint entries.
Each SP entry in the list has an Excel file attached to it.

Without opening each file individually and searching, how would I conduct a simultaneous search throughout all the excel files within this SP list.
That would be great if it drilled down to Cell name on each workbook that contained my text/number. If it at least let me know what workbook to go in and individually search, that would work too.

Let's say for example, each Excel file represented an invoice for a sale. Each invoice listed item serial numbers.
I want to find a specific serial number in my search of multiple invoices (Excel files)
I used this example for illustrative purposes only. I am sure there is a much better invoice creation and management software, or there are plenty of other ways to use Excel to accomplish that type of goal.

In an effort to find a solution to my issue, I have conducted many forum and Google searches without success. I have found some results that almost match, but not exactly.
Closest I have come up with is utilizing a search software to that conduct a search on multiple closed Excel files within the same folder on a shared or local drive.

If there is already a detailed thread covering this, then please direct me there.

Thank you for your assistance,
Price