I have recently moved into a new house and have a sky cable in each bedroom ran straight from the dish. I have connected these cables straight into freeview TV,s but do not receive a signal. Anyone know why and what I need to do to get it working

Nope, different connectors/transmission.
Freeview uses normal areal type transmissions, where as FreeSAT would use the satalite dish connections, with appropriate connectors.