I am trying to build a worksheet where information located in columns A - E of the first tab are autopopulated in the same fields of the second tab of the same worksheet if the word 'Loaner' is selected from the dropdown of column F of the first tab. The information that would need to go to on the second tab would be from the same row in which 'Loaner' is selected.

I hope this makes sense. Not sure if I am describing this clearly enough or not.

Thank you.