Assume multiple worksheets in a workbook (all having the same structure). In a summary sheet, one may want to tabulate data from these multiple worksheets. Essentially, a way to link to the same specific cells in multiple worksheets to the Summary sheet. The formula in the Summary sheet should just be copied and pasted to multiple rows to bring over data from the multiple worksheets.
You may refer to my solution in this workbook.