Excel - Copy rows to total page

Issue

I have an Excel spreadsheet with 13 worksheets. The first 12 worksheets are January through December. The 13th worksheet is a total. Each worksheet has identical columns and rows.

In all worksheets, there are about 10 columns like Date, Name, Address, Account Number, Department, Employee Name, etc...

What I am trying to do is enter the information in each monthly worksheet and have the data I'm entering automatically copied to the total worksheet. The total worksheet would contain all the data entered. I'd have a monthly breakdown, but the total page contains all transactions.

I have all the worksheets set up, but can't come up with the code to do the copy. Any suggestions please?

Solution

Try this. Of course make sure you make a backup of original file before testing
Assumptions.

1. The sheets are names Jan, Feb, ....

2. The Master sheet is called Master

3. The column 1 does not have blank value (it is used to find the max number of rows)