Every month I need to compare the current list of this months projects
against the prior months projects to determine: a) any new projects added
b) any projects deleted c) $ variance from last month to this month for
existing projects.

The project data has separate $ breakdowns per month (ie Jan, Feb, Mar) and
not just a rolling total per year.

Currently I'm doing this via alot of worksheets to maintain vlookups and
calculations to be able to pull all the required data into one spreadsheet
for reporting.

This is very cumbersome because the formulas need to be updated each month
in order to point to the current months financials.

There has to be an easier way. I was thinking queries, but since I'm not
very familiar with them a) Not sure if they are the solution b) if so, woud
it be the same amount of work anyways?

Help please.