How can I arrange data in Ms Excel?

[umgbemena]

The attached workbook has data in different worksheets that need to be aligned to correspond to each contiguous rows from one sheet to another to enable my formula to make accurate analyses. I need each name on each worksheet in the workbook to be in the same corresponding column and rows along with its numerical data on the other worksheets. Is there a way to do this automatically in Ms Excel?

Also asked here How do I organize my workbook data across different worksheets - OzGrid Free Excel/VBA Help Forum

 

[C Moore]

Power Query can merge all of the data sets into a new table that you can refresh as needed.

 

[umgbemena]

Power Query can merge all of the data sets into a new table that you can refresh as needed.

Thanks but I would prefer to not merge the tables. I would prefer a system to arrange the data in each column of a worksheet to correspond with other similar data(in the corresponding columns and cells) in the other worksheets.

 

[C Moore]

I don't understand how the same columns and rows can be the same columns and rows. You'd need to give an example. Can you manually make a piece to share what you mean?

 

[umgbemena]

I don't understand how the same columns and rows can be the same columns and rows. You'd need to give an example. Can you manually make a piece to share what you mean?

Looking at the uploaded excel images, the following names are noticed in the A11 Column of each sheet:

Kira in Column A11 of Sheet1

Tracy in Column A11 of Sheet2

Tony in Column A11 of Sheet3

Groove in Column A11 of Sheet4

Shawn in Column A11 of Sheet 5

Poll in Column A11 of Sheet6

Grace in Column A11 of Sheet7

Bob in Column A11 of Sheet8

Wayne in Column A11 of Sheet9

Grace in Column A11 of Sheet10

What excel method or VBA script can I use to ensure that each of the A11 Columns in each Sheet in my workbook contain the same name and data? This should also apply to other data contained in other A columns. Where a name is not available in any of the Sheets, it could be left blank in the corresponding A11 Column.