Its a bit difficult to fault find remotely as it’s useful to see the type of consumer unit you’ve got, how it’s laid out etc. (any chance of a photo?).
Firstly, it sounds like its the RCD thats tripping as all or part of the house is dead.
Can the RCD be reset with all the MCBs on?
If not then which MCB is causing it to trip/fail to set? (lighting probably). Is it just that MCB?
Can you get the RCD to set with just the lighting MCB on? If so, go round turning on your light switches one by one to see which one causes the trip to occur.
RCD trips are extremely difficult to pin down. The last one I had was due to a faulty neutral on Western Power’s pole outside the property. I was suspicious about it being external as I couldn’t replicate the fault but it was only when I did what is known as an earth fault loop impedence check that I saw an occasional fluctuation in the readings which confirmed it for me.
Based in Pembrokeshire so probably a million miles away from you but if by any chance you’re reasonably local I’d happily take a look for you (FOC).
Rich.