Macro to select sheet and copy data from one sheet to another on new line every time

Hey guys I'm not sure how to do what i want to accomplish, I need to have a function/macro not sure which one for a Tracking sheet. I have a Run sheet i select the track and 1 of the 2 engines and 1 of the 2 rear ends. Each engine & rear end has its own sheet (E.1-2, RE.1-2), I track the starting and finishing position and laps every race on the run sheet, I need that data to transfer to the engine or rear end sheet that i have selected for Example. If i have Engine 1 and Rear End 2 Selected the data from the race Laps and starting and finishing places need the transfer to the sheet selected.
example.xlsx

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.