MS Excel - Worksheet creation

See attached example. I am looking to automate excel to get it to produce a worksheet per room so an engineer can take a printout of the sheet when they go client site to do maintenance visits. Sheet 1 is the main (master) equipment list for all rooms. Sheet 2 is a list of things that the engineer needs to do as part of their visit (dependant on kit type). Sheet 3 + 4 are individual sheet (per room) that are automatically produced and formated so that they can be printed and used by the engineer. Format of sheet 1 will be [login to view URL] number of rooms and amount of client equipment will vary. Can you provide automate the above as needed?