Hi all,

I have around 50 tabs (worksheets) to deal with in a workbook. I have to
come up with a summary in another worksheet that lists down the tab names and
the total items in each tab. So, could anyone please help me figure out on
how:

1. to refer to each of the tab names (i.e Food, Place,and etc.) and place
them in a cell in another worksheet?

2. to refer to each count of the items at the end of the list for each tab?
How can I do it without having to key in them individually?

TQ.

Use INDIRECT() as below.

'the below will refer to cell B10 of tab name specified in cell A1
=INDIRECT("'"&A1&"'!B10")

'the below will get the count of integers in ColA of tab name specified in
cell A1
=COUNT(INDIRECT("'"&A1&"'!A:A"))

--
Jacob


"Rj" wrote:

Hi all,

I have around 50 tabs (worksheets) to deal with in a workbook. I have to
come up with a summary in another worksheet that lists down the tab names and
the total items in each tab. So, could anyone please help me figure out on
how:

1. to refer to each of the tab names (i.e Food, Place,and etc.) and place
them in a cell in another worksheet?

2. to refer to each count of the items at the end of the list for each tab?
How can I do it without having to key in them individually?

TQ.