Create a summary table from 60 tables not all in same format

[Pandadev]

Hi I have 60 tables that I need to create a summary table from , the tables are not formatted the same. With different amounts of columns and named columns. But each table has a Column called QC Check . And each table has a different name for this column. Is there a way to build a table based on this column , so i can do a count of each QC check. So I can show how many rows there are for each named QC check, 

Table QC_1 has 50 rows and the name in the QC Check column is QC Check 1

Table QC_2 has 120 rows and the name in the QC Check column is QC Check 2

Table QC_3 has 75 rows. and the name in the QC Check column is QC Check 3

I would like a table creating like

QC Check - Total

QC Check 1   50

QC Check 2   120

QC Check 3    75

[amitchandak · Accepted solution]

@Pandadev , Not very clear

Try like

union(
summarize('QC Check 1', "Table","QC Check 1", "Rows",countrows('QC Check 1')),
summarize('QC Check 2', "Table","QC Check 2", "Rows",countrows('QC Check 2')),
summarize('QC Check 3', "Table","QC Check 3", "Rows",countrows('QC Check 3')) // so on
)

[Pandadev]

Thanks that worked perfect , I just changed "Table" to "QC Check" as noticed that was the column header name , same for "Rows"