https://docs.google.com/spreadsheets...it?usp=sharing

Hi guys,

On my sheet above..

On my 2nd tab (admin snapshot), in cell C2, I want to take the number from the WC & DS breakdown tab, where it says: Default scores remaining: 1 or 2 or 3 (etc) so in the case of C2, I want to use RIGHT function to get the number from Cell A6

Can anyone please help? I don't know if I need use the RIGHT or VALUE function..??