Sorry to be a nuisance I have given this some further thought, as in two of the sheets the data is the same, sheet 1, entry sheet Columns A&B, then C&D will all appear in sheet 2 - completion sheet (C&D assuming A&B have data entered)
I now need if it can be done that A in sheet 1 will populate A (next available row) in sheet 2. Likewise B will populate B in sheet 2. C&D will likewise populate C*D in sheet 2.

Secondly I have a further issue, I had previously created a form to allow users to add new records quickly, so whilst if entering the sheet manually you must enter data in A&B prior to any of the other columns, if you were to enter data via a new record on the form, and or all of the fields are free, thus allowing a user to add entries into c,d,e etc and not A&B, when I have tested this if you then try and delete these records you can't without putting dummy data into A&B, so my question is, can the mandatory fields be added into forms, or should I just remove the option to populate in theis way?

Thank you