Hi all,

Thanks for all your help so far helping me create a automated DJ Playlist for my Wedding Gigs.

I now have a workbook with about 10 Sheets , each Sheet is a specific Genre i.e. 80's, 70's, House, Top40, Rnb etc...

Clients can now go into each Sheet, select from about 300 tracks by ticking (marking cell with X) and a custom list of their music choices will appear in column F1 (on the same sheet)
So now I have 10 sheets of song selections for each Genre (btw data will end up in columns "F1" in all 10 sheets)

Can anyone help me with a formula so all the data in F1 on all 10 sheets would be copy to a new Sheet...say Sheet 11 - from A1 downward

As you may have guess it would be a master list of of the song choices and would be dynamic so as they add to F1 in various sheets it would update master sheet automatically.

Hope this make sense any help appreciated