Macros and will it carry over to another sheet?

I joined a new company as a sales coordinator, they use excel to do the order forms, one sheet is the enquiry, the second is the picking /delivery note and the third is a payment request.

I need all the info from page one to carry to page three BUT only the quantity of the items and item names as well as customer details to be carried over to sheet 2 because some customers are from resellers of our products so the price will be one thing in the enquiry (sheet 1) because it’s our paperwork but sheet 2 (delivery note) is what the customer will sign when they get it delivered.

The documents are all password protected and no one knows the password, so when I drag the column across to make space for a ‘what 3 words’ location it doesn’t carry across to the delivery note because it goes over other writing, also the the email doesn’t carry over from sheet 1 to sheet 3?

I’ll copy and paste the info to a new document but how do I set up macros to have everything carry across or specific parts to carry over?

Thanks in advance