You would need to copy and paste or enter manually the data in the new sheet. The submitted data always goes into the "All Responses" sheet.
Great thanks. It would be good to be able to allow certain columns to take data from the form and add into these sheets. This will allow us to create personalised reports which can be seen. i.e. each tab would have a filtered report with only the columns we need.
I made note of your suggestion.