Make up your daily sheet with all the information you want as your basis. Based on what I could glean from your post, I would have one workbook with separate tabs for each group: band/dancers, crew, artist.

At this point, I think it should be saved as a template: File: Save As, choose Excel Template for the File Type. Call it something like "Daily template".

Close Excel. Now when you open Excel to start a new sheet, File: New and select the template. When using templates, when you modify the sheets, you will be prompted to name the new sheet upon saving or closing. Thus, the underlying template is never changed and you can keep reusing it over and over again.

Next step, Excel journeyman level: locking cells that shouldn't be edited and protecting the sheets in the template.

If you need additional help, please post your first cut and I will be glad to help.