We have a spreadsheet that sets up fixtures (schedules) for a number of sports teams. Fixtures are added, deleted and changed fairly often. One spreadsheet collects all of the teams fixtures and puts them into chronological order with all of the details necessary for export as a CSV file and import into a Calendar. ('calendar' sheet)

However, it would be great to automate the link process!

The link to the Calendar would work so that any changes in the spreadsheet were reflected on the Calender.