Control find function in record macro

hi guys

i'm an absolute beginner who has been using macro only occasionally. i do not have a grasp of manual VBA code but i use record macro function to achieve some very basic tasks.

i'm struggling with a macro that will allow me to include Control F (Find) function

the issue

I want to copy a cell in Sheet 1 and the search for that same value in sheet 2

once found i then want to copy the cells adjacent to my original cell to the same row as cell i found in sheet 2.

the record macro function doesn't seem to work for this.

could anyone help please