Need help sorting data

Hello, 

I am using a Microsoft Form to receive daily vehicle checks from drivers.  I have 6 possible vehicles in the fleet. The form entries compile into an Excel Online spreadsheet. I want to create separate sheets for each vehicle and have the data automatically sorted as it is received into the appropriate sheet. 

If someone enters a check for vehicle 1, it goes into vehicle 1's sheet. This is possible with google sheets just not sure how to do this in office.

Thanks