Macro for button won't transfer data to another sheet

Originally Posted by titchroberts

Thanks, it doesn't come up with a bug - but then it also doesn't transfer the data to the other worksheets. Any other suggestions on what it can be?

Is a Data filter out of the question?