Excel arrays keep moving when copying formulas

So I'm trying to write a formula that takes subtotals from one sheet for each month for various charges in unique accounts and pastes them on another sheet for the grand total in that account. I tried to use the transpose function to get the row to column argument which, works great for the first month. However, when I try and copy and paste the formula throughout the sheet I run into problems. Because the cell where the formula needs to go is 4 cells to the right (as opposed to the usual one) my array keeps shifting and I don't get the right values. If I lock the arrays with $, I only get the first value in the array. Any ideas how to cycle through those values without modifying the formula based on the pasted location?