Worksheet links
 

Hi, I have several worksheets that have an identical template which contains
several tables, each worksheet is named by location and I want to create a
summary worksheet within the same workbook. I can easily link the worksheets
manually then copy and drag the formula down but since I have several tables
in the template I can't just copy and drag the formula for all I have to do
each table separately. Any easier suggestions?