Create summary page for multiple sheets that counts unique values in column E by tab

[javifais]

I have a workbook with 19 tabs(sheets). Each tab has the same column headings but the data is different. I want to create a summary page which would list the name of each tab and unique count of data in column E of each tab.

The summary page would look something like this:

Tab name	Unique values in column E for this tab
Sheet1	100
Sheet2	25

<tbody>
</tbody>

 

[javifais]

I should clarify that the datatype in column E is text. Also, I am looking to get distinct count, as in SQL.

 

[javifais]

I found that the formula =SUMPRODUCT(--(FREQUENCY(MATCH(E2:E61,E2:E61,0),ROW(E2:E61)-ROW(E2)+1)>0)) gives the unique count correctly but in my case the range will not always end at E61. This formula cannot handle blank spaces.