Combining data from several sheets
 

Good morning all,

I am trying to combine data from 4 tabs into 1, but only where data exists.

Basically, I have 4 sheets of information that pulls from another database based on the date. Sometimes this is blank because nothing happened that day, and sometimes there is information here. I want to be able to show all this info on just the 1 tab so that it is easy to see the complete list in one place without having to click through tabs.

As always, all help greatly appreciated

Jooniper