Can anyone please help with this as i dont know much about VBA

I have a workbook made up of multiple sheets, columns B-H contain the data and column A is a reference to that data

I would like to search through all the sheets to find n (whatever i input) and return that value on a new sheet along with its reference in column A

Many Thanks