Quarter $2$ Spreadsheet:

Notice comment in cell C$23($always read any comments that are available$)$ always use the previous quarter for projected sales of Q$2-$Q$4.$

Also notice YTD $($year to date$)$ this is a new piece of information to calculate

Step $1$: Fill in data using the data from Q$1$ as the base, advance the value from prior quarter by projected percentage using a formula

$$ Need to place an Absolute Reference on E$23$ to copy for the rest of the spreadsheet $($$E$$23)$

$$ Copy formula to all data spots

Step $2$: Fill in all totals

Step $3$: Fill in YTD $$ use a formula

Step $4$: Center and merge the Title