I have multiple sheets that contain data. I want to create a summary page
that holds all the data on every tab into one newly generated sheet. For
Example:

On one sheet "C22" = 1 and is set to "C44" = China
On the next sheet "C22" = 3 and is set to "C44" = Japan

The newly generated sheet would present:
C1 = 1, D1 = China
C2 = 3, D2 = Japan

I have some ideas, but a macro set to a button would be best. What code
could I use?