Microsoft Excel Tips and Tricks
The method I demonstrate requires you to house all your data in Excel tables and then to name those tables. You can then refer to the table names with the INDIRECT function to return multiple ranges in one formula.
Credit Chester Tugwell