Pulling my hair finding code that can help me, hate not providing anything but if anyone can help what I'm after should be pretty simple.

I want a code to find certain text in Column E in Sheet 1(example "San Fransico") and paste 50 cells below that into Sheet 2 range D4. I can then adjust the code to search based on cell value and change event when that cell changes the macro runs. I just need a push start as I'm not getting anywhere with the above. Any help is hugely appreciated and apologies again for not having an example, nothing i tried came close.