software

I'm using Excel 2000 to maintain a membership list containing details
such as first name, last name, address, age, gender, ethnicity etc.
This document is kept up to date on a daily basis and at the end of
each month I transfer some of the details on to a front sheet that
tracks month-by-month totals e.g.

JanFebMar
GENDER
Male150181168
Female132156158
etc, etc

So far I've tried a couple of methods to pick up the info for the
front sheet:
1. Referring the cells on the front sheet to a total on a pivot table
held on another worksheet
2. Using the COUNTIF function

Both methods work OK but each month I have to copy the formulae into
the new month's column and then copy the previous months figures and
paste special into the previous months column as values only.
I am about to pass this spreadsheet on to someone else to maintain and
if they forget to do the quot;paste specialquot; bit, then the previous
months column will display the current months figures.
I've tried recording a macro but it repeats in the same columns. I
need it to move along a column each month, is there a simple way to do
this (my knowledge of VB is zero)

Thanks for your help

Jacob Thomas