File #1 contains about 150 sheets. Each sheet sums the values in a column and puts the result in cell A20 (for all sheets the result is also in each sheets cell A20).

File #2 is a summary of the 150 sheets in file #.

I have two questions:

1) How do I have the names of each of the 150 sheets automatically appear in a column in file #2?

2) For each of the 150 sheets, how do I have each of the results in the respective cell A20 also appear in a column in file #2?

Thanks,

Brett