List Tabs and Column Heads
 

I have a spreadsheet from which I need to list all tab names (in a column)
and all column heads (against each tab name).
I need to create this table in a brand new spreadsheet.
Ive seen posts that use modules to list tab names, but I dont know how to
use modules.
Once I have my list of tabs, is it possible to use the tab name to reference
to the first cell in the tab? Eg, in cell A1 = TabName, in cell B1,
='[SpreadsheetName.xls]A1'!A1

List Tabs and Column Heads
 

You have a workbook called WorkbookName.xls, you have listed the Sheets/Tabs
in column A of Sheet1 in a new workbook called New.xls, and you want to
display the value of the first cell in each column from each sheet:
In cell B2 Sheet1 of New.xls, insert this:
=INDIRECT(CONCATENATE("'[WorkbookName.xls]",$A2,"'!",ADDRESS(1,COLUMN()-1)))
Then fill down and across as required.

"Hugh Murfitt" wrote:

I have a spreadsheet from which I need to list all tab names (in a column)
and all column heads (against each tab name).
I need to create this table in a brand new spreadsheet.
Ive seen posts that use modules to list tab names, but I dont know how to
use modules.
Once I have my list of tabs, is it possible to use the tab name to reference
to the first cell in the tab? Eg, in cell A1 = TabName, in cell B1,
='[SpreadsheetName.xls]A1'!A1