Ok, I realize this has to be a very simple solution but I have looked and looked and cannot find the answer. I'm using the following formula to copy vertical column data from one sheet into a horizontal row of another.

=INDEX('1'!$G$14:$G$225,COLUMNS($B:C))

Then the next row would be:

=INDEX('2'!$G$14:$G$225,COLUMNS($B:C))

what do I need to change so that when I drag the above formula down, the tab number increments automatically?

Thanks in advance!!!