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:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Tab name[/TD]
[TD]Unique values in column E for this tab[/TD]
[/TR]
[TR]
[TD]Sheet1[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]Sheet2[/TD]
[TD]25[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.