Question

In order to conildate the data from different parts of the sheet , use

Answer 1

You can use (Data > Consolidate) to combine the corresponding values in up to 255 different worksheets into a single worksheet. Your data can be consolidated from several different source, either on the same worksheet, on different worksheets within the same workbook or even in different workbooks.