Excel can do transposition from Row to Column and vise versa. Can it
transpose from Row to Sheet?

E.g. from:
Sheet1 A1 10
Sheet1 A2 11
Sheet1 A3 12

to

Sheet2 B1 10
Sheet3 B1 11
Sheet4 B1 12

I use Excel 2003.

Thanks