Well I'd prefer an automatic way, since there are about 60 sheets, with
possibly more to come. Each sheet is named with the number of the survey (id
Test24) but they are not consecutive, as a number of them aren't being
included.

I want to try to name the range and then input the name as the source for a
pivot table, but this really isn't working and I don't know why.

"Dominic" wrote:

Great.

So, does my answer suit your needs? Or are you looking for an automatic way
do this? How many sheets are in the workbook?

What is the naming convention (if any) for the sheets?

"RebeccaW" wrote:

Yes - that's exactly it. There must be a straightforward way to do this, but
I've been working at this for a couple hours and haven't figured it out.
Thanks,
Rebecca

"Dominic" wrote:

Rebecca,

I'm not sure I understand exactly what you are looking for.

Are you saying, you have sheets: Sheet1, Sheet2, Sheet3, SummarySheet.

On Summary sheet, you want:

A B
1 Sheet1!A2 Sheet1!A4
2 Sheet2!A2 Sheet2!A4
3 Sheet3!A2 Sheet3!A4

?

"RebeccaW" wrote:

I'm analyzing a set of political science surveys. Each survey has its own
worksheet in the same workbook. I'm creating a summary on which I want to
show two sets of results from each survey - so I want two columns, one of
which shows A2 from each worksheet, and parallel, A4 from each worksheet.
You can't create lists across difference worksheets, though. Can anyone help?