This is definitely the case. When I have a complicated (for me) programming issue with my website, I will sometimes dream about it and work out another solution to try. I wake up and it works like a charm. I think it's a combo of our brain having a "quest" to complete mixed with the wider knowledge of the universe available to us subconsciously as we sleep. We can't access it directly, but bits fall it to fill the holes we need.