Search for a part number in all (max 20) sheets of a workbook

The nubers within a sheet is structured from level zero (top level) to max level 9. If found in a sheet return level zero part number and description
as well as the part numbers & descriptions of the next three higher level parents. I am new to VB and have no experience as yet. Please supply the
code to use. Example worksheet posted.

hi Oujous, welcome to Excelforum, please check attachment, press Run button. The result is on a new sheet. I've made some assumptions on my own, please check if it's OK with you.

Thank you very much for resolving my problem in such a short time. Can you please send me the code.

save attachment, press ALT+F11, the code sits in Module 1

Please Login or Register  to view this content.

Thank you very much watersev. You are a star.