It shares the clipboard. It is probably a problem with what you clipped. I doubt Numbers is smart enough to take an html table and paste it into cells.
If you can supply a link to the site I'd be willing to play around and see if I can come up with something more useful to say, but the odds are against it.