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'!C4With a tab named Bookings, =Bookings!C4 is enough. The exclamation mark separates the tab from the address.

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.

Illustrated source change test.



