How to refer to data on another sheet with an array formula in Excel- Destination data tab

Example of how to refer to data on another sheet with an array formula in Excel- Destination data tab