Title may be a little too ambiguous but I'll try give a run down as best I can;
I have a Google sheet with multiple "Sheets" or Tabs (as I'd like to call them) within it.
The Main tab is blank and the rest have various cells with different dates on them. The dates that are close turn their respective cells Red. I have existing conditional formatting to do this.
What I want to achieve is the main tab basically checks all the other tabs for any red cells and pops them into the main sheet in a vertical column.
Here's an example:
(A1) Date 1 (green)
(A2) Date 2 (red)
(A3) Date 3 (red)
(A4) Date 4 (Green)
(A1) Date 2 (red)
(A2) Date 3 (red)
As you can see, "Main tab" ignores any green cells from "Second tab" and only grabs the red ones. In my case though, there are many more tabs, not just 1.
I have a feeling "=IMPORTRANGE" may help in this scenario? Maybe.
Any help is greatly appreciated!