Macro - Copy Paste to Another Sheet If Value in Column is Number

[Matt1998]

Hello

I'm trying to simplify our ordering lists on a monthly basis based of a master stock list. (about 1000 rows)

I can't quite figure out how to create a formula or macro to copy an entire Row onto a seperate tab within excel (or new file whichever is easier) based on where there is a numerical value in a certain column. Column Q, T, W, Z (To start with)

These columns need to be independant of one another when I come to run the order form based on the date/month in these columns. Maybe I can enter a date into a field or formula before running the macro.

Finally I then need to arrange the data in column E in alpha order. I'm trying to keep it as simple possible.