change last cell in column

I also found another way to help, I think..

In cell B2 on sheets April and May, you have a formula pointing to cell B38 on the previous sheet. As you mentioned, the last row might not be 38 for a given month, so instead of '=March!B38', '=April!B38', etc., use this for cell B2 in April:

=OFFSET(March!B2,MAX(IF(NOT(ISBLANK(March!B2:B50)),ROW(March!B2:B50),0))-ROW(March!B2),0)

For May!B2 change the month reference to April, like so:

=OFFSET(April!B2,MAX(IF(NOT(ISBLANK(April!B2:B50)),ROW(April!B2:B50),0))-ROW(April!B2),0)

PS - If anyone reading this has better ideas to automatically change the month, by all means do share.

UPDATE: Those are array formulas.. you must press CTRL+SHIFT+ENTER after typing them, not just ENTER.