Insert text from a cell in another worksheet

[Loggy1]

Hi

I am trying to insert text from cells in another worksheet as follows:

I have a front sheet named "Front Sheet". Column A is already populated with a list of company names. Column B is for Contact names, Column C is for email address.

Each company has its own worksheet, and is named as the company name. Therefore, on "Front Sheet" Column A is essentially a list of worksheet names.

In each worksheet Cell B3 is the contact name, cell B5 is the phone number and cell B7 is the email address.

I have used =CELL("contents",BMW!$B$3) to return the contact name for BMW, but rather than typing in each worksheet name I would like to get the formula to look up the text in Column A to automate the whole process. Any ideas?

Thanks

Tom

 

[Loggy1]

Bump

 

[Aladin Akyurek]

Hi

I am trying to insert text from cells in another worksheet as follows:

I have a front sheet named "Front Sheet". Column A is already populated with a list of company names. Column B is for Contact names, Column C is for email address.

Each company has its own worksheet, and is named as the company name. Therefore, on "Front Sheet" Column A is essentially a list of worksheet names.

In each worksheet Cell B3 is the contact name, cell B5 is the phone number and cell B7 is the email address.

I have used =CELL("contents",BMW!$B$3) to return the contact name for BMW, but rather than typing in each worksheet name I would like to get the formula to look up the text in Column A to automate the whole process. Any ideas?

Thanks

Tom

=INDIRECT("'"&$A$2&"'!B3")

Note that formulas like this are costly because of their volatility.