He is now 24 weeks, he's walked for a good amount of time daily, fed a good diet, played with , cuddled, kept busy with challenges but things are getting worse.
Firstly, puppies need about 18 hours of good sleep each day. About 8-9 hours a night, and the rest in good chunks throughout the day. Is he getting that amount? Too much stimulation is not the right way to go - you need to find the balance between exercise, training, feeding, sleep and play. At that age, I would be doing 2 x 30 minute walks per day to include a mixture of off-lead time (if possible, or on a long-line if not), training and slow sniffing. Puppies shouldn't be playing rough, so avoid things like throwing balls and tuggy if possible.
He climbs all over the table, skirting board and now tonight jumped in the counters and eaten all the meat for dinner.
What are you doing to prevent it? I would be using baby gates, a pen and a crate to limit where he's got access to - and you shouldn't be leaving him in any room alone at that age, really - more for his own safety than anything else. You don't want him to bite/chew something like a wire.
Mine is three and we still use a baby gate to keep him out of the kitchen!
He's ripping carpets up, eaten dining chairs , dug huge holes in the garden , scratched the sofas to death.
Where are you when all this is happening? Can you not crate him when you need to leave him alone?
I do feel for you because the puppy months can be really hard, but I feel like a lot of this could be prevented if you put the right measures in place.