We usually maintain the data in multiple worksheets to check the data for each instance and to view them individually but it would be great to merge all the data from different worksheets in Excel spreadsheet to analyze it.
Consolidate feature in Excel 2010, lets you to pull-each record from the worksheet in to one master worksheet, which adds-up all data from spreadsheets.
Exam 1: Repeat the same procedure in other sheets to assign them name range exam2 and exam3 respectively.
As you weigh the pros and cons, keep in mind that timing is critical.
With just a few exceptions, you get only one chance to consolidate with the government loan programs.
To combine just a couple of sheets, you may not need anything else but the good old copy/paste.
But if you are to merge tens of sheets, errors with manual copying/pasting are inevitable.