collating data from multiple standardised excel spreadsheets help!

Hi i have an excel document with one main index page and over 100 different identically laid out spreadsheets as tabs, each displaying the same information for different subjects. Each spreadsheet has the exact same name as on the index page, and all are hyperlinked to their respective index page. on each of the tabs there are just over 100 data points and i want to collate 15 of this 100 onto the index page for comparison purposes. doing this manually would take too long is there any other way of doing this?

By: Jake

Leave a Reply

Your email address will not be published. Required fields are marked *