I would like to list on one sheet, the values of a cell B2 from about 20
worksheets

This list would run down a column of the master worksheet ie B1,B2,B3 etc

Ideally this list would automatically expand if more sheets were added,
perhaps by having a blank 'FIRST" and 'LAST" sheets at either end?

I can see how to do the linking by hand, one at a time, but is there a way
to do it by formula?

In fact I'd like to make two lists on the master sheet- one would be names
from all the B2 cells and the other would be corresponding numbers from all
the I12 cells