how to filter the data from multiple workbooks by enter the value of the data in excel

Occasional Visitor

Hi All, 
I am new in group and excel platform to genera the tool for data search having multiple massive workbooks in excel.

 

I am looking for the compatible ways to design formulas for searching the associate data in rows from multiple worksheets by just enter value of data. 

 

 

I appreciate your quick response. 

 

Best Regard

0 Replies