Macro for button won't transfer data to another sheet

Originally Posted by Richard Buttrey

Is a Data filter out of the question?

I have tried that but because of the way the form is set up, the information doesn't sit in subsequent rows. It is more the information is in individual cells. But I can see how this would be easier.