I'm trying to select any cell in Col A and click on the button "Go To List" and it should take me to Sheet2 and hightlight the cell with selected value (I'm basically trying to write a macro co copy a specific cell in col A in Sheet1 and search in Col A in Sheet2.

example I select 1004 in sheet1 and click on the button it should take me to Sheet2 and search for 1004 and highlight/select that specific cell/row is also fine.

I'm stuck with the half code any help would be appreciated.