I am a new user of excel, self taught and am not finding it easy!
I am making up a simple spreadsheet for members of a club. Each week they
pay different amounts of money, which is broken down into 3 categories. My
workbook is made up of worksheets for each member (approx 60 people/'tabs').
I have columns as follows

A B C D E
F G
Date Balance b/f Total due Admission Tea Fund Holiday Fund
Balance c/f
1 Jan 10.00 4.00 1.00 1.00
2.00 10.00
7 Jan
14 Jan
etc

Cols D, E & F total to Col C
Col G = B+C-D-E-F
There will be 52 columns, one for each week of the year.

I will bank the money collected every week, into 3 separate accounts. I
therefore want to do a 'summary sheet' as follows

A B C D E
F G

Name B/f Total Admission Tea
Holiday C/f
J Smith
D Brown
etc

Amounts banked x x x
x

How can I easily transfer the figures in colums B-G of members' sheets to
the summary sheet? I could do it if the rows were static, but as they will
move forward by one row each week, I am stuck, as I am really new at this.
Thanks in advance for any help anybody can give me.