Where can I find a spreadsheet that works like iTunes?

[karma3]

Looking for a spreadsheet that works like itunes

I am in a band and would like to take better control of our song list. We have a spreadsheet master list of our songs that contains 9 fields of info: song name, key, what each member is playing/doing etc. We create set lists from this master. Here's the thing though that I can't get a regular spreadsheet to do. If I make a change to the master, say we change the key we are playing the song in, I want it to change the entry in the set list.
Since a regular spreadsheet doesn't treat other work pages as aliases like iTunes treats playlists, I have to repeat any changes I make on multiple sheets.
Anyone know of a "spreadsheet" that acts more like iTunes? I don't need any formula ability, just the availability of multiple fields and sorting options.

 

[SwitchBeach]

Re: Looking for a spreadsheet that works like itunes

Have you tried using a database program (such as Access) and creating queries?

Or in Excel, when you create the playlists, have the cell in the playlist sheet be a reference to the master list sheet (rather than a straight copy-and-paste entry)?

 

[Ledsteplin]

Re: Looking for a spreadsheet that works like itunes

Google sheets?