Macro to create formula for Main Page from data on other page

I have already had multiple people helping me to create these Macros that are currently in place.

I am trying to get the Main Page to look at each of the area pages and pull info from those pages.

I need the main page to reflect data input on the Area pages from Column C to Column AO.

I used an IF statement initially (=IF('Area Page Name'!C1=0," ",'Area Page Name'!C1). This works just fine as long as I don't add any rows of data to my main page. When I add rows of data to my main page, then the references no longer work properly as the area may have changed. I could add data at any row spot, not just at the end.

Any help would be appreciated.

I have attached the spreadsheet I have been working with

I see several pages in the attached file. Which is the main page that you are talking about? I dont see any Main page in your file. Can you explain the requirements again?