Please help me if possible as below

MY TEXT IN SHEET NUMBER 1 C3 (DELIVERD) TO MOVE WORKSHEET
NUMBER 2 IN C3, HOW TO MOVE AUTOMATICLY***

the below is i have work sheet 1
A1 (shipper) B1 (consignee) C1 (arrival date) D1 (b/l number)
somthing
like this finaly delivery option for example H1
when i enter in cell H1, then all above to move worksheet 2, but i
dont want see the above after entry from sheet 1 H1 this purticular
row to move sheet 2 last blank row,


if it is possible, please provide solution.


Best Regards
Anshad