I have a worksheet that has a column for a Y or N answer. If the user
answers Y, I want a macro to run to jump to the other worksheet. I
need the macro to run for each input of Y going down the worksheet.

So, how do I link a macro to a Y or N answer in a cell, and how do I
make the macro run relative to the cell with the Y answer?

Any help on this is greatly appreciated.