I have a workbook with numerous worksheets in it. Each work sheet has
information down colum A. In the first Worksheet i want it to gather all the
information in colum A of each persons Sheet. For example. In the main
worksheet it will say Employee1!$A$1 in Row 2 Column B. What i am trying to
do is copy that formula, but I dont want to have to change the names. Is
there a function code that i can do so that it will automatically change the
names?

I dont know if this makes sense, but any help would be appreciated.

hi, John !

I suppose that you will need the name(s) for each person/sheet...
somewhere in your gathering resume, say... in column/row titles ?
after that, you could use indirect(...) worksheet-function (or other sort of alternates)

what you have not commented yet, is where you need the data gathering and it's "source" cell/range -?-

regards,
hector.

__ original post __
I have a workbook with numerous worksheets in it. Each work sheet has information down colum A.
In the first Worksheet i want it to gather all the information in colum A of each persons Sheet.
For example. In the main worksheet it will say Employee1!$A$1 in Row 2 Column B.
What i am trying to do is copy that formula, but I dont want to have to change the names.
Is there a function code that i can do so that it will automatically change the names?
I dont know if this makes sense, but any help would be appreciated.

I would say the easiest thing to do is copy the formula, then highlight each
column at a time and do a find/replace. Doesn't stop you from having to
change the names, but you do it once per employee instead of however many
rows you may have.

"John" wrote:

I have a workbook with numerous worksheets in it. Each work sheet has
information down colum A. In the first Worksheet i want it to gather all the
information in colum A of each persons Sheet. For example. In the main
worksheet it will say Employee1!$A$1 in Row 2 Column B. What i am trying to
do is copy that formula, but I dont want to have to change the names. Is
there a function code that i can do so that it will automatically change the
names?

I dont know if this makes sense, but any help would be appreciated.