I wonder if there is a simple solution to this time saving idea:

So my company's products are coded in this fashion:

BE#####-X-Y OR BE#####-X1-Y1/X2-Y2

Basically each product has different versions (different #####), and different configurations (combination of X and Y, in which both are whole numbers such as 0,1,2,3...)

So I had found a way to call these different spreadsheets using Macro when I need to look into a specific product's details. Now, to bring it a step further. Any suggestion for:

1. Prompts me to enter X and Y, and brings me to the right worksheet. It gets a bit tricky here because some of our products offers 2 sides, that means that one side could be X1-Y1 and the other could be the same (if it is the same, we just keep it simple as X-Y) or X2-Y2. The order of the side does not matter (X1-Y1/X2-Y2 AND X2-Y2/X1-Y1 are the same).

This is an example of how the tabs look like: \1

2. Prompts me to enter the ##### and search for the next cell that matches this partially.

Please let me know if there are simple solutions, otherwise, we can look into a commercial service agreement.

Thanks!