I WOULD LIKE TO MAKE A NUMBER CREATED, WHEN USING COMMAND BUTTON, TO TRANSFER NUMBER FROM ONE CELL INTO THE ONE SELECTED. FOR EXAMPLE BELOW.

Private Sub CommandButton1_Click()

Range("D2 SHEET4").Value = Range("c21")

End Sub

IS THE EXAMPLE OF WHAT I AM TRYING TO ACCOMPLISH. I WOULD LIKE THE INFORMATION IN C21 ON THE SHEET I AM CREATING THE COMMAND BUTTON ON TO PUT THAT INFORMATION INTO CELL D2 ON SHEET 4 OR CALLED "EXPENSES".

I KNOW ITS PROBABLY VERY SIMPLE, BUT I AM TRYING TO ACTIVELY MAKE THIS SHEET MORE INTELLIGENT.

Look at the Sheets collection to find the Sheet object for the page.
Worksheets("Expenses").Range("D2").Value = ActiveSheet.Range("C21").Value
This is untested, so might need some tweaking.