For some reason my account no longer has cherub rock but my sons account does. It's on the same computer where we play. All the older cdlc is still playable on my account but anything new I add to the folder only adds to his song list and not my account that no longer shows cherub rock. Any suggestions?

Sounds like your putting your songs into the wrong install folder, which can happen if Steam decides it wants to move your game to a better location. Right click on Rocksmith in steam, and go to Manage > Browse local files. Open the DLC folder. If your songs are in there, then something is up with your install, but if your songs aren't then that's where you need to start putting your songs for them to show up.

 

Turns out I'm an idiot. Over an hour yesterday and today trying to solve this. I had my songs sorted by favourites. I favorited all my previous CDLC and a few other songs in the game. All the new stuff I put in the folder and cherub rock were in the game just not selected as a favourite. I bow my head in shame

Glad you got your issue solved though!