Hi

I am looking for the VBA to select all cells on column "Q" on multiple worksheets that are over the value of 1200 and paste them with the corresponding name of the worksheet they are found in, to a new worksheet.

For example

NEW SHEET

Sheet 1 1200
Sheet 2 1234
Sheet 3 1400

Could anyone please possibly help?

Many thanks