you could bring the data from each other sheet by this sort of formula =Sheet2!D25, can't think of an easy way
just select the cell where you want it to appear, enter = then navigate to the data you want displayed, select and enter. Then drag to fill the range you want
How?Why not use a macro tot get all data on sheet.
Then you can use filter (or pivot table) for analyzing.
How to use a macro?
How to use a filter?
How to use a pivot table?
You question is not clear.