Flexible Multiple Spreadsheet Data Consolidation System

Methods and systems are disclosed that include consolidating data from multiple spreadsheets. Consolidating data from multiple spreadsheets includes receiving a selection of a plurality of spreadsheets via a graphical control panel that includes a spreadsheet selection area. The spreadsheet selection area includes a workbook selection area to select workbooks that are not open for inclusion in the selection of the plurality of spreadsheets. Consolidating data from multiple spreadsheets further includes receiving a selection of portions of data from the plurality of spreadsheets and executing automated consolidation of the portions of data by retrieving the portions of data and generating a final report spreadsheet. Consolidating data from multiple spreadsheets further includes appending the portions of data to the final report spreadsheet.