How many cables you need depends largely on how many- and what type- of satellite receivers you want to run. For example, a recording Sky box or a twin tuner Satellite recorder needs two feeds off the LNB. If you have a second recorder box elsewhere then that too will need 2 feeds. Satellite tuners (no recording or only "record what you watch") will take a single feed. If your TV has a Freesat tuner then this will usually be a single connection.
Most people's experience of satellite is either via the Sky service or Freesat. These aren't the only services, but let's deal with them in isolation for the moment. The signals for both services come from the same satellite. So a dish aligned for receiving Sky with work for receiving Freesat of the tuner/recorder boxes are swapped.
The dishes erected for Sky/Freesat use will typically have an LNB with 4 outputs. This will feed either 2 recorders (2 cables each) or 4 tuner boxes (single cable each) or 1 recorder + 2 tuner boxes.
4 output LNBs aren't the only type available though. There's an 8-way version too.
Installs that are more complex will use something called a Quattro LNB (still 4 outputs) and then feed that signal in to a device called a multi-switch. You'd find this sort of arrangement in very large houses, and in hotels, and in blocks of flats.
I mentioned earlier that Sky/Freesat aren't the only satellite services available. The sky is packed with satellites, all of them at different geo-stationary orbits and beaming their signals down to earth. The UK receives signals from lots of foreign language satellites. To pick up those signals often requires a different dish and LNB and for that to be pointing at a different part of the sky. So, what cables you need does depend on what you want to receive and then how you want to deal with the signal.
What is it that you want to do.... recieve Sky/Freeview or something else instead/as well. Then how many rooms do you want to feed that signal to?
P.S. If you find the answers here useful, please use the Thanks button at the top right of the specific post. It costs you nothing and it helps others when they're searching for answers. Thanks