I have created a Excel dashboard with a search window & would like it to find the results from 45 worksheets in a workbook

[MrSteel1234]

I' am using Excel 2019 and i have created a dashboard with a search window & i would like to be able to enter a part number in the search window and have it go through all the worksheets and display the results. The worksheets are all set up the same as far as columns & rows they are column A. Category B. Part Number C. Manufacturer D. Description E. Qty F. Price G. Total H. Grand total. When i enter a part number into the search window i would like the following columns to display information A. Category B. Part Number C. Manufacturer D. Description E. Qty. I have the column headers that i want displayed pasted below the search box already i just need to have them populate after a search is used. I have tried several =FilterXML formulas and i have not had any luck but i could be missing something as im new at writing formulas. I have tried the consolidate list function with no luck and my VBA skills are not so great and have been having a hard time with using it. I have uploaded two screenshots one is of the dashboard & the other is the layout of how all of the 45 work sheets are set up.