Hi

I have a workbook with a list of values in column A

Example

112.33
443.22
116.44

then i have a folder, with 5 workbooks within, with multiple sheets ( up to 100 )

them values above will be somewhere on a sheet in the above workbooks, what i need is to loop / open each workbook

find that value, then list the sheet name and file name in column B/C on my original workbook next value im looking for

many thanks in advance!