Using cell contents to search for corresponding sheet title

In Visual Basic, is there a way to make a cell’s contents into a variable that will then search the sheets for the corresponding variable?

For some more detail, if Sheet 1 looks like this:

41	X	2
24	Z	3
10	X	5

is there a function to make Sheet "41" look like this:

X	Y	Z
2

and Sheet "24" to look like:

X	Y	Z
		3

And Sheet "10" to look accordingly.

EDIT:
I've made some progress, I have this code in place:

Please Login or Register  to view this content.

This allows me to put a 1 in cell "A1" of each sheet, now I need for it to search for the adjacent contents in Column B and find it in the corresponding sheet and place the number in column C in the correct area.