Is it correct to say "There's many a ..."? [closed]

Yes, it is correct. It's a phrase that is combined with a singular noun. From http://oxforddictionaries.com/definition/many:

many a: a large number of

Many a good man has been destroyed by booze
John and I have talked about it many a time