Use of Individual Cells from Different Sheets in an Array instead of Range of Cells?

Is it possible to make it so an array has a list of cells to include vs. a range of cells (i.e. A2:A10).


So instead of writing A2:A5,B2:B5 you would have B2:B5 be something like ('Sheet 1'!B2,'Sheet 2'!B2,'Sheet 3'!B2,'Sheet 4'!B2,'Sheet 5'!B2)?