User Form - Insert Row then Data

Okie Dokie here we go....

I have created the user form with the fields that I need. Please see the attached file

When I submit this form, I need the following to happen:

(1) Insert New Row at row 48
(2) Static Date in B48
(3) "Long code" into C48
(4) "Long enter Auto" into D48
(5) "Short code" into G48
(6) "Short Enter Auto" into H48

(J48, K48 & L48 I need the ability to populate these cells with custom formulas...)

THEN, the same userform send the same info into another workbook "Alerts vs Actual" but in different cells

(1) Insert New Row at row 22
(2) Static Date in A22
(3) "Long code" into B22
(5) "Short code" into C22
(4) "Long enter PTA" into D48
(6) "Short Enter PTA" into H48
(7) Long Enter Auto" into L22
(8) "Short Enter Auto" into P22

(E22,G22,I22,K22,M22,O22,Q22,S22 I need the ability to populate these cells with custom formulas...)

I know it's a bit of an ask but anyone that can help i'd be very appreciative!

THANKS!