Try This....
SELECT *
INTO #Table1
FROM
(SELECT '1' serial, 'E001' empid, 'AAA' empname, 'Mumbai' location,'a@gmail.com' email
UNION ALL
SELECT '2', 'E002', 'BBB', 'Pune', 'b@gmail.com'
) AS TBL
SELECT *
INTO #Table2
FROM
(SELECT '1' serial, 'S001' empid, 'CCC' empname, 'Mumbai' location,'c@gmail.com' email
UNION ALL
SELECT '2', 'S002', 'DDD', 'Mumbai', 'd@gmail.com'
) AS TBL
SELECT *
INTO #Table3
FROM
(SELECT '1' serial, 'F001' empid, 'EEE' empname, 'Pune' location,'e@gmail.com' email
UNION ALL
SELECT '2', 'F002', 'FFF', 'Hyderabad', 'f@gmail.com'
) AS TBL
SELECT *
INTO #Table4
FROM
(SELECT '1' serial, 'G001' empid, 'GGG' empname, 'Mumbai' location,'g@gmail.com' email
) AS TBL
SELECT *
INTO #Table5
FROM
(SELECT '1' serial, 'H001' empid, 'HHH' empname, 'Hyderabad' location,'h@gmail.com' email
) AS TBL
SELECT * INTO #CommonTable
FROM(
SELECT serial,location FROM #Table1
UNION ALL
SELECT serial,location FROM #Table2
UNION ALL
SELECT serial,location FROM #Table3
UNION ALL
SELECT serial,location FROM #Table4
UNION ALL
SELECT serial,location FROM #Table5
) AS TBL1
SELECT location,COUNT(serial) FROM #CommonTable GROUP BY location