Is there any date field available in those tables? Can you provide any sample data?
How much I understand to get a global calendar you need to use Canonical date situation. You need to create a Link table containing all dates from all tables. This Link table will be used to generate global Calendar. Below is a probable structure-
Hope that helps.
Thanks for your response. I do not have full date. only year, month and quarter information in each table
below is the sample data table 1 all other are same
Year Quarter Month Cotacts Responses FY-2015/16 Q1 April 9 21 FY-2015/16 Q1 May 9 14 FY-2015/16 Q1 June 9 14 FY-2015/16 Q2 July 9 14 FY-2015/16 Q2 August 8 21 FY-2015/16 Q2 September 9 21 FY-2015/16 Q3 October 4 21 FY-2015/16 Q3 November 4 7 FY-2015/16 Q3 December 4 0 FY-2015/16 Q4 January 12 7