I was given this task and it is giving me trouble. If someone could help me
that would be great!

Attachment is the excel sheet with two monthly tabs (test tabs). I would
like the candidate to create a new tab in same excel sheet and add both tab
(August and September) and keep the sum and same formulas in new tab.

They should use formula to add two tabs if you make a change in monthly tab
it should automatically change in the new tab they created.