Update Cells from Certain Tabs based on Value other cells

[Erika7]

I have a workbook with 1 tab per calendar day for basic Hotel/guest management system. Each tab has a table to manage daily check in / check out info & payments made by customers. I want to be able to have a formula on each tab that recognizes the check in & check out date and:
1) Updates all future tabs (dates) until that customer checks out with their name & rate info so it doesn't have to be copied each day
2) Have a running balance on their balance that's carried over daily.

There's only 15 rooms so each tab doesn't get too busy, however, it's difficult to track each customers payments since many of them stay for over 1 week and sometimes multiple months and their payments aren't consistent. 1 person may pay daily cash/credit card, another cash every few days as a lump sum. This being said, need to be able to easily see on each day's tab which customer is up-to-date or behind on payments.

Example scenario with 3 customers over 3 days (Note changes in Name Info, Prev. Balance & Balance columns based on payments):

1st Tab: Jan 1
[TABLE="class: grid, width: 25, align: left"]
<tbody>[TR]
[TD]Room[/TD]
[TD]First[/TD]
[TD]Last [/TD]
[TD]Check In[/TD]
[TD]Check Out[/TD]
[TD]# Nights[/TD]
[TD]Nightly Rate[/TD]
[TD]Total Rate[/TD]
[TD]Amount Paid[/TD]
[TD]Previous Balance[/TD]
[TD]Balance[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]John[/TD]
[TD]Smith[/TD]
[TD]1/1[/TD]
[TD]1/4[/TD]
[TD]3[/TD]
[TD]$25[/TD]
[TD]$75[/TD]
[TD]$25[/TD]
[TD]$0[/TD]
[TD]$50[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]John[/TD]
[TD]Doe[/TD]
[TD]1/1[/TD]
[TD]1/2[/TD]
[TD]1[/TD]
[TD]$30[/TD]
[TD]$30[/TD]
[TD]$30[/TD]
[TD]$0[/TD]
[TD]$0[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Jane[/TD]
[TD]Doe[/TD]
[TD]1/1[/TD]
[TD]1/3[/TD]
[TD]2[/TD]
[TD]$25[/TD]
[TD]$50[/TD]
[TD]$30[/TD]
[TD]$0[/TD]
[TD]$20[/TD]
[/TR]
</tbody>[/TABLE]









2nd Tab: Jan 2
[TABLE="class: grid, width: 25, align: left"]
<tbody>[TR]
[TD]Room[/TD]
[TD]First[/TD]
[TD]Last [/TD]
[TD]Check In[/TD]
[TD]Check Out[/TD]
[TD]# Nights[/TD]
[TD]Nightly Rate[/TD]
[TD]Total Rate[/TD]
[TD]Amount Paid[/TD]
[TD]Previous Balance[/TD]
[TD]Balance[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]John[/TD]
[TD]Smith[/TD]
[TD]1/1[/TD]
[TD]1/4[/TD]
[TD]3[/TD]
[TD]$25[/TD]
[TD]$75[/TD]
[TD]$0[/TD]
[TD]$50[/TD]
[TD]$50[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Jane[/TD]
[TD]Doe[/TD]
[TD]1/1[/TD]
[TD]1/3[/TD]
[TD]2[/TD]
[TD]$25[/TD]
[TD]$50[/TD]
[TD]$20[/TD]
[TD]$20[/TD]
[TD]$0[/TD]
[/TR]
</tbody>[/TABLE]









3rd Tab: Jan 3
[TABLE="class: grid, width: 25, align: left"]
<tbody>[TR]
[TD]Room[/TD]
[TD]First[/TD]
[TD]Last [/TD]
[TD]Check In[/TD]
[TD]Check Out[/TD]
[TD]# Nights[/TD]
[TD]Nightly Rate[/TD]
[TD]Total Rate[/TD]
[TD]Amount Paid[/TD]
[TD]Previous Balance[/TD]
[TD]Balance[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]John[/TD]
[TD]Smith[/TD]
[TD]1/1[/TD]
[TD]1/4[/TD]
[TD]3[/TD]
[TD]$25[/TD]
[TD]$75[/TD]
[TD]$50[/TD]
[TD]$50[/TD]
[TD]$0[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]