Use the =indirect() function. I use ti all the time

For example -name your tabs "John', "Joe", what ever

Then use Col A to hold the names of the tabs or another cell if you
want

Lets say you put "John" in A2

then this function will show cell B23 on Johns tab.

=INDIRECT($A2&"!b23")

Very powerful

HTH

JDB


jjjam wrote:
Imagine one Excel spreadsheet with 20 worksheets within; each worksheet
assigned to a team member; and each worksheet containing the monthly
accomplishments of that team member.

What I need to do is merge the text of each worksheet into a "summary"
worksheet, showing Joe's accomplishments, then Judy's, etc. etc.

I'm looking for any ideas how best to do this. Any help is GREATLY
appreciated.

Each worksheet is identical in format.
Row A B C
1 Date Accomplishment Hrs Worked
2
3
4 Date Meetings Attended Hrs Spent
5
6
7 Date Training Hrs
8
9