To modify macro based on criteria in input sheet to lookup on criteria then extract data

Hi All

I have several several database in a workbook which refers to specific suppliers .

The imput sheet is named sample column A and B are blank when clicked on button , macro triggers lookup sample Data base and extracts from database column C header reference, if no data is found column A and B remains blank.

What I am looking actually is modify the macro or better solution I have added a search criteria column L in imput sample sheet

That is lookup in L2 criteria and search on the sheet tabs if it tallies then lookup in that sheet tab to perfom lookup and extract data column C and D

Take note thre will be 20 supplier sheets tabs or more

Thanks if anyone can help