Hi

Sorry I trawled through the questions and none really applied to my issue.

Here is the scenario - I have 80 seperate worksheets in one spreadsheet
file. Column A is the list of headings (questions in my case) on each row,
and Column B is the response (data).

Each worksheet is set out like a survey so there are some rows that contain
a "heading" but no corresponding data (ie the field in column B is blank for
asthetic purposes).

So that I can run pivot tables on the collected data, I want to combine all
of the information from the 80 odd worksheets into one. They are all based on
a template, so Column A will always be the same. So what I want is to bring
all of the data in Columb B from each worksheet. I want each column to be
identifed by the worksheet name.

Is this possible??

As a footnote, FYI I describe myself as an intermediate user (so if you can,
dumb it down for me), and I may have a need of adding additional worksheets
and therefore data in the future. Finally I really really do not want to have
to cut and paste each set of data...