|re: This then needs to be sent to a gate pass sheet in the same worksheet which is made in to a vehicle pass and printed off.|
I assume you mean "sent to a gate pass sheet in the same workbook" since you can't have a "sheet in the same worksheet"
From your description, it seems pretty straightforward...
If the data entry sheet is named, for example, "Vehicle Info", and the gate pass sheet is named, for example, "Gate Pass", just use:
=Vehicle Info!A5 in Gate Pass!C2
=Vehicle Info!A7 in Gate Pass!E2
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.