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.