Cell values of Multiple sheets into single sheet

[someone21]

For example, there is a "main" worksheet and 5 other worksheet. For the 5 other worksheet,there are rows of data with the first row being the header. And in there, the column H, there is an option of Yes/No.

So now I want to get a summary in the "main" worksheet of all the rows of the 5 worksheets which contain Yes. So how to get the data?

 

[Smitty]

Welcome to the Board

You can record a macro applying AutoFilter to column H for Yes, then copying the visible cells to the main worksheet.

If you post back what you get someone can set it up to work on all sheets.

 

[someone21]

Welcome to the Board

You can record a macro applying AutoFilter to column H for Yes, then copying the visible cells to the main worksheet.

If you post back what you get someone can set it up to work on all sheets.

Correct way, but I forgot to add, I really do not want to use Autofilter function...

So what other methods.....

 

[Smitty]

Correct way, but I forgot to add, I really do not want to use Autofilter function...

Uhhh, why?

You can always remove it after you've copied the relevant data.

 

[someone21]

Uhhh, why?

You can always remove it after you've copied the relevant data.

Erm,

but what if some new data arrives in the one of the other 5 worksheets, how could I automate this process without the use of autofilter. this is my idea...

And if we are talking about autofilter, any way to make the data of the different 5 sheets into a table like? For example, I can select whichever column I want, and I get the list, the total count, the rows of those who satisfy the requirement.

 

[Smitty]

How is the new data coming in?

Do you have any unique identifier for each of the records? I.E. how do you tell new data apart from previous data?

 

[someone21]

How is the new data coming in?

Do you have any unique identifier for each of the records? I.E. how do you tell new data apart from previous data?

New data will be added manually to any of the 5 worksheets according,so therefore I want it to be automatically in the "main" worksheet.... (so I can just click a button, and get to the know everything according to my criteria(which in this case is Yes/No for column H).

And new data will always have a different column E compared with other rows.