I have an Excel workbook with multiple spreadsheets. Each spreadsheet has a different list of items with multiples columns (with headers) for various values including dates and text info. These spreadsheets represent the status of a particular file so for example, one spreadsheet lists files that are currently active, another lists those that are outstanding, and another has those that are closed. Each spreadsheet utilizes the same headers in the same order, allowing me to transfer items freely from one spreadsheet to another without needing to rearrange info in it's row. What I want to do it create a master sheet that automatically combines all items and their info into a single list, automatically updating the information and values manually entered in the individual spreadsheets. Personally I would easily be able to do this if the values were not constantly being updated daily, but they are. In addition I routinely move items from one spreadsheet to another based upon their status. If this sounds like something that is not feasible please let me know and if you can offer a suggestion for an alternative I would certainly like to hear it. Thanks!
Edited by Zook, 17 January 2014 - 11:25 AM.