Looking up value accross multiple shhets

I have a workbook called BR1 Fixed asset. I want to look up the asset number in Col C in the source workbook and look up the asset number in the destination workbook so as to find the value in same column as the text Net book value

For eg if asset 7183 is in Col C I want to find the Net book value of this asset which is 129117.69 (in the scol where heading is Net Book Value)

The destination workbook has been converterd from PDF into Excel using a PDF converter so Net Book Value is not in the same col for all the sheets in the destination workbook-see attached sample

Your assisting in creating a formula to look up the value will be most appreciated

So you want the macro to first find the sheet where the asset code is mentioned, and then look at the Net value column and return the corresponding value?

I have also posted this on the following site


Formula to extract data based on Asset number | Windows Secrets Lounge