Spreadsheet: 79343d1279632741-trying-to-copy-workbooks-to-new-folder-while-retaining-relative-links-between-workboo-yearly-summary-sound-and-light-show
Sheet: Collation

 | Sound and Light show (Yearly total) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Day 8 | Day 9 | Day 10 | Day 11 | Day 12 | Day 13 | Day 14 | Day 15 | Day 16 | Day 17 | Day 18 | Day 19 | Day 20 | Day 21 | Day 22 | Day 23 | Day 24 | Day 25 | Day 26 | Day 27 | Day 28 | Day 29 | Day 30 | Day 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sunday
 | Number of Paxe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday
 | Money Taken |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday
 | Number Prepaid |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday
 |  | July | August | September | October | November | December | January | February | March | April | May | June
 | No of Paxe
 | Money Taken
 | Money Taken / 10
 | Number Prepaid
 | Day tours (Yearly total) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Friday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Saturday
 | Number of Paxe
 | Money taken
 |  | July | August | September | October | November | December | January | February | March | April | May | June
 | No of Paxe
 | Money Taken
 | Money Tken / 10
 | Heard From Stats
 |  | July | August | September | October | November | December | January | February | March | April | May | June
 | [NAME]
 | Sound & Light Show - No. Of [NAME]
 |  | July | August | September | October | November | December | January | February | March | April | May | June |  |  | Totals
 | Monday
 | Tuesday
 | Wednesday
 | Thursday
 | Friday
 | Saturday
 | Sunday
 | Total
 | Daily average for month
 | Sound & Light Show - Money taken
 |  | July | August | September | October | November | December | January | February | March | April | May | June |  |  | Totals
 | Monday
 | Tuesday |  |  | 76
 | Wednesday
 | Thursday
 | Friday
 | Saturday
 | Sunday |  |  |  |  |  |  |  |  | 126
 | Total
 | Daily average for month
 | Sound & Light Show - Prepaid
 |  | July | August | September | October | November | December | January | February | March | April | May | June |  |  | Totals
 | Monday
 | Tuesday |  |  |  |  |  |  | 76
 | Wednesday
 | Thursday
 | Friday
 | Saturday
 | Sunday | 126
 | Total
 | Daily average for month
 | Daily Tours - No of Paxe
 |  | July | August | September | October | November | December | January | February | March | April | May | June |  |  | Totals
 | Monday
 | Tuesday
 | Wednesday
 | Thursday
 | Friday
 | Saturday
 | Sunday
 | Total
 | Daily average for month
 | Daily Tours - Money Taken
 |  | July | August | September | October | November | December | January | February | March | April | May | June |  |  | Totals
 | Monday
 | Tuesday
 | Wednesday
 | Thursday
 | Friday
 | Saturday
 | Sunday
 | Total
 | Daily average for month