I don't know how many worksheets you plan on having but this could get very big in a hurry.

If I was doing this, I wouldn't have a worksheet for each G/L Acct. All the data gathering can be done from the Data Worksheet by either using a Table or the Filter on the Data Tab. If a copy was needed to print, filter the records to get what you want, select the range of cells filtered, Go To Special, Visible Cells, copy, and paste on a new worksheet.

The monthly statistics can be gathered by using a TOTALS row on the table if you choose to use a table. Just filter for the G/L the other criteria that you need and the totals will be presented to you in the last row as they apply to the filtered data. In the totals row, you choose for each column what you want the totals to be.