Update One Spreadsheet from several others based on a Flag

[kpierce]

First, thank you to everyone for the support. Your help has been tremendous.

I have one last question, I am sure this can be done, but I really don't have any idea where or how to start.

I have one 'master' tab that is a roll up from 6 different sundry tabs.

In the 6 sundry tabs, there is are flags in R25:R31, if one of these fields is equal to "Y". Then the specific line (example I25:Q25, or I26:Q26, or I27,Q27) need to be pushed/pulled over into the master tab in the next available blank area in Master!J24:T30.

For example Sundry!I25:Q25 to Master!J24:T24, or Sundry!I26:Q26 to Master!J25:T25.
NOTE: The Sundry tab could turn the flag on and off, so that would have to automatically update the Master.

The more I think about this, I doubt it can be done in any type of formula. If the only route is a command button, that is fine. Not optimal but this is ok. I could put a CommandButton on the Master tab and have it read through all the Sundry tabs.

Again, everyone's help is much appreciated. You have saved me many hours of frustration.

thanks in advance.