I have quarterly data, which I want to divide into monthly colums. For example:

Sheet 1 -
Cell A1 has data for Q1
Cell B1 has data for Q2...etc

In sheet 2 -
Cell A1 has data for Q1 Month 1
Cell B1 has data for Q1 Month 2
Cell C1 has data for Q1 Month 3
Cell D1 has total for Q1
Cell A1 has data for Q2 Month 1
Cell A1 has data for Q2 Month 2...etc

The column reference needs to increase by one every fourth column, but I
can't figure out a way to do it.