Equipment Register - Copy data to one sheet based on condition

I am very new to VBA, but am learning quickly. I would like to be able to copy rows of data from multiple sheets to a master sheet "On Hire", if a piece of equipment is on hire. There are multiple sheets associated with the type of equipment, each is the same and column 'I' lists if it is "ON" or "OFF" hire. I have looked all over but nothing seems to work in the way I would like. I have attached a copy of the spreadsheet layout with some example data in to make it clearer.
If anyone could point me in the right direction, any help would be much appreciated.