I have 50+ tabs in excel with a summary sheet. The data in each tab is quite basis with a few columns of data and one of the columns has a figure.
I want in column A of the summary sheet to contain the name of each tab. At the side of the tab name I want it to sum the total of a specific column in each tab (same column across all tabs).
Other than lots of clicking, is there a clever way to do this quickly?