Maybe a little further explaintion:
The workbook contains many worksheets (Tabs) such as Company A, Company B,
etc. Each worksheet will always contain material data in cell Z1 (for
example). Normally the formula for B1 would be ='Company A'!Z1. What I need
is a template that I can copy to any workbook, that will retrive the data
from Z1 for what ever name I type in A1. Basically I need a formula that will
substitute whatever is typed into A1 for "Company A" in the above formula.

"vezerid" wrote:

In B1:

=INDIRECT("'"&$A$1&"'!"&ADDRESS(1,COLUMN()))

HTH
Kostis Vezerides

Sparky13 wrote:
A B C D
1 [Worksheet / Tab name] Material Labor Overhead
2

I need to make a template which I can copy into differant workbooks. In the
above example I would like to input the worksheet (or tab) name into A1 and
have excel fill in the information for B, C, & D. The worksheet (tab) names
will always be different but the cells in the worksheets which contain the
data for B,C,D will always be the same. I could have as many as 50+
worksheets in the workbook. I know I may get errors in B,C,D if A is blank
but I can deal with that.

Question: What is the formula for cells B,C,D to:
1)look at the name in A
2)find that worksheet and
3)copy the date from that worksheet to cells B, C, D?