A patch panel is simply a load of potential connections - its up to you how you setup. I would set it up so your router and switch ports are connected to one part of the patch panel and you then connect your distribution ports in your rooms to another bank on the patch panel - you can can then jump across the patch panel without having to fiddle around with the wiring to the network components. Perhaps use some sort of colour coding and labelling method. Its simply a means of making changes and maintenance easier - its not really anything to do with ICT or networking. I don't bother at home with one - but I don't have as many data points as you appear. to..
Its worth bearing in mind higher density switches have uplink ports - usually two for resilience - but unless you have suitable equipment and know what you are doing JUST CONNECT ONE of the up links to a core switch or your broadband router switch port.
Also where you have 8 ports on the ground floor I would be inclined to have a dedicated switch for that - possibly a switch for each floor and then you connect the uplink port(s) from each switch to one or more central switches (Again unless you know what you are doing just use one link to one central switch).
I use a switch for each main room and a cooperating WLAN (multiple access points load balancing between them) for all other rooms. I use VLAN trunk connections between the switches and I use aggregated links between the switches for optimum performance. The central switch is a layer 3 switch (i.e. it routes between VLANs) . The VLANs map to different WLANs, work and private use as well as diagnostic VLANs. If your wiring man is also a basic network man he should understand that and can suggest if this would provide any advantage for you ... given the large number of data ports you are proposing for a home network some care might be required so as to avoid broadcast flooding especially if you have a single subnet for WLAN and ethernet etc and this where things like IGMP snooping and higher grade devices really start to matter if your network performance and networks app are not to suffer - If you only intend to use a smaller subset of the ports at a time however and the number is more for physical convenience as opposed to capacity then this should not be an issue.
So given your questions
- the ethernet [ports] needs to be connected to the patch panel,
- similarly the NASs would not be connected to the patch panel?
- also there are bigger patch panels than 24 no. ones?
1.. YES as per my description above
2.. NO the NAS and other hosts would be connected to the patch panel - where you would use a patch lead to connect to your switch as I describe above
3.. YES