I am trying to combine multiple workbooks together into a Summary workbook.
Each workbook has different formating, but has the same information. How do
I go about doing this? Is it even possible?

For example:
Each (15) workbooks has student grades.
Summary workbook has all student grades combined.