Need help copying custom spreadsheet formats to 2014

[jbroulette]

Let me start by stating that I am at best an Excel Rookie and that I wish I had 10% of the knowledge that most of you here have.

Last year I built a custom spreadsheet for my little trucking business that is just perfect for me. I am trying to copy the entire setup for this year and am having problems.

It has three pages, a 2013 Main page and two accompanying pages that have data on each trucks earnings and expenditures. The data on the main page tabulates data from all three, along with general expenditures. I tried to just copy each page, clear the contents and then go in and change the formulas that reference the 2013 pages to now use data from the 2014 pages. That didn't work. The columns did not zero out after I cleared the contents of the pages and, when I entered some trial figures into the spreadsheets, it was ignored buy the formulas.

Any help figuring this out will be greatly appreciated.