Linking to External spreadsheets

Expert advice please! I need to pull data from 130 different spreadsheets. I need to go into each spreadsheet (each have 40 tabs) - add a tab to summarize the data in each sheet and then pull that ...