Find cells from different workbook ,and workbook name is also from different worksheet.

hi all

I have a problem here, i have gotten a task in that i have to find cells(values) from different workbooks. and the names of workbooks are not to be given in macro. the names and Paths have to be get from a different worksheet.....if some one have the idea ......then please help me

Well you could have a sheet in the "master" workbook where you could write down path\path\file.xlsx and start from there...
With the little info you gave us it's a bit hard to help you.