Hi Gary,

You can use the INDIRECT worksheet function for this.

Cheers


"gbeard" wrote in message
...
I have 6 different sheets in my workbook 1 for each of my 5 different
districts in my company and one main sheet. Is it possible to put the
district number in a cell on the main sheet and then reference that cell
in
an IF statement to pull data from a particular district? By changing the
value in that single cell, I'd be able to find the same data from each of
my
districts.
BTW, I can't use a VLOOKUP or HLOOKUP since the data I am trying to pull
is
not in numerical order.

Any help or ideas would be appreciated,
Gary