How to auto-populate worksheet based on cell entry?

[tgcali]

Hello,

If I enter an ID# in cell I2 I need the data from cells A1 to H32 from that
individual's worksheet to auto-populate in the same place on the current
worksheet. Is this possible?

There are numerous worksheets, each representing a specific person. I would
need to be able to have the data from A1 to H32 brought up for any individual
based on the ID# entered.

Thank you in advance for your assistance. I appreciate any help.

tgcali

 

[KC Rippstein hotmail com>]

I assume each sheet tab's name is the ID#. In that case, in cell A1 use the
following formula:
=INDIRECT("'"&$I$2&"'!A1")
Copy that formula to H32 using the auto-fill handle.

 

[tgcali]

I appreciate your answer and that would work, but unfortunately they're just
named sheet 1, sheet 2, etc. up to sheet 250. The ID# is located in cell B2
on each sheet. I apologize, I should have specified that from the beginning.

I'm choosing to look based on ID# because I needed an easy way to call up
the specific data needed for any individual. We need to set it up to be able
to email specific data but not the entire individual worksheet. So I chose to
create a new workbook to be used just for the email puposes. I am creating
this sheet in the current workbook to call up the necessary data, add
additional data and then export to the new workbook to be emailed. I can take
care of the rest easily enough, I just seem to draw a blank on how to call up
the necessary block of data from A1:H32. Thanks again for your help.

 

[KC Rippstein hotmail com>]

You'll still be able to use the indirect formula, but you're going to have to
do one of two things first:
- rename tabs to the ID # (why resort to sheet1, sheet2, etc. when they
serve no purpose for you?)...then the formula I gave you will work just fine
- or make a master list of ID # and corresponding sheet name, then in the
indirect formula you'll use vlookup (I assume you won't choose this way as it
is less intuitive, since you're going to have to check each sheet anyway
might as well just change the sheet names as you go)
If you go the second route, just give your master list a name, like IDList,
then use this indirect formula:
=INDIRECT("'"&VLOOKUP($I$2,IDList,2,0)&"'!A1")

 

[tgcali]

Thanks you! Worked like a charm.

I appreciate your answer and that would work, but unfortunately they're just
named sheet 1, sheet 2, etc. up to sheet 250. The ID# is located in cell B2
on each sheet. I apologize, I should have specified that from the beginning.

I'm choosing to look based on ID# because I needed an easy way to call up
the specific data needed for any individual. We need to set it up to be able
to email specific data but not the entire individual worksheet. So I chose to
create a new workbook to be used just for the email puposes. I am creating
this sheet in the current workbook to call up the necessary data, add
additional data and then export to the new workbook to be emailed. I can take
care of the rest easily enough, I just seem to draw a blank on how to call up
the necessary block of data from A1:H32. Thanks again for your help.