The Room Bookings tab holds a count of 18 in C4. On Summary, put Bookings received next to the cell that should read that value.

Point the summary cell at its source

Enter this formula in the empty summary cell.

='Room Bookings'!C4

With a tab named Bookings, =Bookings!C4 is enough. The exclamation mark separates the tab from the address.

Single quotes surround Room Bookings because the sheet name has a space.

Illustrated same-workbook reference syntax.

Verify the summary responds to a source edit

In a copy set C4 to 19 and confirm the summary also reads 19. Reopen the saved XLSX and read the formula bar to verify that the number still comes from the source. If the summary shows #REF!, check the tab and address before replacing anything.

A change in C4 from 18 to 19 appears in the summary value.

Illustrated source change test.

Related Microsoft Excel reference