I do a monthly stat sheet that lists a member number in column B, in column
D is the total number of work done. Each month the list has the same data in
column B and D. But Column B may have other people added or subtracted each
month.

The common worksheet has everyone listed in column B.

Each month I would add a new worksheet for the previous month, Is there a
formula that will allow me to reference the previous month by column B and
place column D data in a cell that would reference the new worksheet? Column
D data would move each month to a new cell on the common worksheet.

I would end up with 13 worksheets, one for each month and then a common
sheet that would add the totals of each persons data by month.

End result would be

A B C
ID Jan Feb

11 0 15
12
13 11 6
14 2
15 7 7
16 22 17
17 5 10

Thanks for any advise or suggestions
Steve