Working with tabs and calculating across multiple ones

Welcome to the Forum cgsweger!

You haven't really given enough information. "I need to be able to calculate the %, year to date..." Percentage of what? Are you calculating the commissions, or just recording them? "I have row 3, column b3 thru m3" What data is in that row?

The best way to ask this type of question is to attach your file, although I would remove or change the vets' names for privacy purposes.

Also, your data organization makes life hard. The optimal organization for this type of data is to have a single sheet with one row for each transaction, which includes the date. Then you don't need a new sheet for each year, and you don't need 12 columns for 12 months. Once you have that, you can use a pivot table to automatically report on the data in every way imaginable.

To post a file:

1. Under the text box where you type your reply click the Go Advanced button.
2. In the next screen look above the reply box and click the "paper clip" icon. You will get a pop-up screen.
3. In the pop-up, click Add then Select to select a file from your local drive
4. Click the Upload button to upload the file
5. Click Done to attach it.

It will be displayed as an attachment underneath your post text. Alternatively as the last step you can click the Insert Inline button and a hyperlink to the file will be inserted directly into your post text in the spot where your cursor is set at the moment you click the button.