Make 1 Pivot Table from 2 Tables - Income and Expense - with different columns.

HI.
I've 2 tables - 1 is Orders table which captures the income and other is an Expense table which captures daily expenses. Both these tables are on 2 different worksheet of the same Workbook. I want to create an Overview of Income and Expense on a 3rd worksheet named "Overview" where I would be able to see Income & Expense of a particular selected month (or ALL months).

The tables are as follows:-
1. Orders table (Income):
Date |Bill No.|Customer|Mob. No.|Society|Room No.|Product|Qty|Type Vendor|Category|My Rate|Vendor Revenue|Splash Revenue

2. Expense table:
Date|Category|Amount

Please help. Thanks.

Hi Richard.
As requested I'm attaching the workbook with a few sample data. I've mentioned what I need to do in the file itself in a textbox.
Let me know if it makes sense.
Thanks.

It works perfectly well. I had assumed it wouldn't upon viewing the formula as I thought the Range name would have to be updated every time as I enter new data since range is increasing. But I was wrong. Worked brilliantly.
Thanks..