Question

the changing the position of the data within the same worksheet​

Answer 1

$\huge{\green}\fcolorbox{blue}{cyan}{\underline{\color{p}{Answer}}}$

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.