VBA Macro to search for unique ID from one file in multiple sheets of another file

Hi guys,

I'm very new to this and just getting into programming so looking for some assistance with getting this Project going. I was after a macro that would search for a unique id such as 'CBX495-1' in column A, Row1 of one workbook (Workbook1) containing only one worksheet, in another workbook (Workbook2), containing multiple worksheets, using Workbook2's file name and path. I would like the macro to list where the unique id can be found in Column B of workbook 2.
I would also like the Macro to move on to Row 2, Column A of Workbook one and repeat this until all rows in Workbook1 have been searched.
Is this possible in excel?

Any assistance would be greatly appreciated.

Many thanks,
Tim.