This I think is a simple solution. Just that I have spent too long trying to do it.
I have a worksheet named, "ABCD" and have headings from A1....D1 e.g. forename, surname, department, age
I want to copy and paste this line into my other worksheet "EFGH" at the same place.
How is this done?