I need a goMacro that I can tell it when to start to run other macros until
Sheet1 P5=28

I already have the following macros that do basically this (below) but I
have to click a separate buttons for each because I have to stop when the
cell that sums Sheet1 D5:L5 (Sheet1 P5) is equal to or greater than 28. Here
are my macros:

Macro1 = copy from Sheet2 cells F1:F2 then paste special values in Sheet1
D5:D6 then delete Sheet1 F1:F2 shift rows up.

Macro2 = copy from Sheet2 cells F1:F2 then paste special values in Sheet1
E5:E6 then delete Sheet1 F1:F2 shift rows up.

Macro3 = copy from Sheet2 cells F1:F2 then paste special values in Sheet1
F5:F6 then delete Sheet1 F1:F2 shift rows up.

Macro4 = copy from Sheet2 cells F1:F2 then paste special values in Sheet1
G5:G6 then delete Sheet1 F1:F2 shift rows up.

Macro5 = copy from Sheet2 cells F1:F2 then paste special values in Sheet1
H5:H6 then delete Sheet1 F1:F2 shift rows up.

Macro6 = copy from Sheet2 cells F1:F2 then paste special values in Sheet1
I5:I6 then delete Sheet1 F1:F2 shift rows up.

Macro7 = copy from Sheet2 cells F1:F2 then paste special values in Sheet1
J5:J6 then delete Sheet1 F1:F2 shift rows up.

Macro8 = copy from Sheet2 cells F1:F2 then paste special values in Sheet1
K5:K6 then delete Sheet1 F1:F2 shift rows up.

Macro9 = copy from Sheet2 cells F1:F2 then paste special values in Sheet1
L5:L6 then delete Sheet1 F1:F2 shift rows up.

When Sheet1P5=28 run Macro10

So in other words, I click the goMacro button and Macro1 does its thing. If
Sheet1 P5=28 then run Macro10, otherwise run Macro2 and so forth.

Thank you,
Jeff