I am trying to summarize my data on the last sheet of the workbook.... the
sheet names will change frequently..... so what I am trying to do is have a
cell (column header or name) on the summary sheet automatically read the name
on each sheet and use it in the cell for my header-- Then when the sheet
name changes it will automatically update my summary page... Is this possible?
Thanks