I have several large spreadsheets that are exactly the same except cells have different numbers. I would like to create a new spreadsheet to compare the data in just some of the cells of the original spreadsheets
As a example I would like the new spreadsheet to show the numbers from the A1 cells of the original spreadsheets and also the numbers from the W20 cells of the original spreadsheets. The new spreadsheet would show that Spreadsheet A had some number in cell A1 and Spreadsheet B had some number in in cell A1 and spreadsheet C had some number in cell A1. Also, The new spreadsheet would show that Spreadsheet A had some number in cell W20 and Spreadsheet B had some number in in cell W20 and spreadsheet C had some number in cell W20 How can the above be done? Is there some way to "consolidate" just some cells from different spreadsheet into a new spreadsheet?.
