Consolidate data from two sheets of same workbook

Hi Team,

I have a worksheet which is having two data sheets getting data from SQL Query. Now Issue is that I need to combine both data into one sheet. I have tried to create macro which copy data from both worksheets one by one and copy it to one. But it does not work properly. I need to just combine both tables. I have attached an example sheet for the same.

Is there any function that can help to combine this data or macro. I have tried to modify SQL query but its not working. So I think only excel function or macro can do this.