Macro to combine multiple worksheets

Hello,

I am trying to consolidate three different worksheets into one.
All three worksheets are exactly the same format with different data.
I'm in excel 2010. I can't seem to find the "wizard" to choose multiple data sources to create a pivot.

Also I tried using the consolidate function, but it just subtotals the information which is what I do not want.

I'm even open to have just one column. (Column A) combined so that I can run vlookups for the other columns. But I can't figure out how to do that.
Oh yeah, these sheets are dynamic and will be updated daily.

Can I create a command button that will bring all the info together?