A Way To Have Multiple Tables In One Table?

[Kristen_Gerzin]

We have a rolling bonus for each of our sales representatives and appointment setters. In total there are 10 people eligible for this.

Currently, I have table created for each individual with the data to calculate their rolling bonus.

Columns include:

• Month
• Client Job (linked to another table)
• Contract (rollup)
• Production (rollup)
• Qualified (formula)
• Multiplier
• Bonus (formula)
• Rolling bonus (formula)
• Account ledger (linked to another table)

Is there a way for me to apply all users to this one table instead of having 10 separate tables?