Cut and Paste Rows from multiple Worksheets on to one summary sheet based on 1 condit

[SiChambo]

Hi All

I have a workbook with multiple sheets (below)
Data
Switchboard
Active Projects
and sheets numbered 1 thru to 10 (could be more)

What I am trying to do is summarise all the worksheets from 1 to 10 but only if a condition is met.

There is a drop down list in column A with multiple entries however when I select "Active Project", I want to Cut (not copy) and paste the entire row on to the Active projects worksheet next available line.

I would prefer this was a command button so the user can make changes to his information before moving the rows.

There are many similar answers but I cannot get them to work.

Many thanks in advance.

[snb]

Which answers did you test on which data ?

Why not posting a sample workbook ?

[SiChambo]

SNB Hi

Its a large workbook with quite a bit of sensitive material so I do not wish to share the content, Would you like me to post a blank version?
If so how do I do that when I have already started the thread?

Si