Sheet 1 is for Store 1. In column A I have dates, in column B I have
profits. Sheet 2 is for Store 2 with the same data as Sheet 1. However,
there is not necessarily an entry on every date. For example, Store 1 could
have entries on 1/1, 1/2, 1/5. Store 2 could have entries on 1/1, 1/3, 1/5.

How can I consolidate the data from these two sheets into one to look like
this:

1/1 Store A profit Store B profit
1/2 Store A profit
1/3 Store B profit
1/5 Store A profit Store B profit

So basically, I would want to consolidate the dates in column A with no
duplicates, and then have column B list Store A profits for that day (if any)
and column C list Store B profits for that day (if any). And then I can
manually total Store A + B into column D.