Use Pivot Tables, or functions such as VLOOKUP and SUMIF. Now you should be able to consolidate the data more easily. If you need to differentiate the data (I assume that’s why you have separate sheets), do so with an additional column. That should be no problem, since you indicate they all have the same structure. However, if you MUST continue to use a spreadsheet only approach (and depending on the amount of data being maintained), I would suggest you combine all data spreadsheets into one single spreadsheet. It seems to me you need more than a spreadsheet approach you need a database backend with a spreadsheet frontend. And I will continue to enhance the main sheet, so I need to be able to move columns and do other data manipulation operations exactly as I would on any normal sheet.Īll my formatting, sorting and column rearranging will be limited to the main sheet. The solution needs to be robust in that the main sheet will continue to function as expected even when I paste new data into the other sheets. There will be an arbitrary number of rows. The column structure in the other sheets will always be the same. To update my data I will need to be able to simply paste new data into the other sheets. However, in my main sheet, I need to be able to aggregate all the data as well as rearrange it. Each of these other sheets will have the same structure (same columns). And I cannot change the structure (such as moving or adding columns). I will have one main sheet that summarizes and presents all the data from the other sheets. I want to combine all A2:A10 in every sheet into a new table. How can I combine multiple tables, in different sheets, into a new one?Įx: There are 26 data sheets in my file, Apple, Ball, Cell, Diary… Zebra. How to combine multiple tables, in different sheets, into a new one? English

Libreoffice sheets