Yes, I could use the"=" but that will require I keep going back and forth
between the worksheets. I need a template to copy to many workbooks all with
differant tab names. If I can just type in the tab name it will be faster and
more virsatal

"Khoshravan" wrote:

YOu can include workbook name in the reference of an address for a cell.
One solution is that, put "=" in B, C, D and then click the required cell
from the workbook you need. In this solution you should not change the
filename or move it to another folder.
This solution doesn't use the name of workbook stored in A.
HTH
--
Rasoul Khoshravan Azar
Kobe University, Kobe, Japan


"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?