We use an online service to store client information and use excel to visualize a portion of that information. Presently, I type the information into excel manually from the (password-protected) site. I would like to know if it would be possible to copy the table from the web page (using Ctrl+C) and paste the clipboard contents into excel. The columns do not align, or else I would simply paste in excel, matching destination format.

The webpage table is in the following format:
A1 B1 C1 D1 E1 F1 G1 H1
A2 B2 C2 D2 E2 F2 G2 H2
etc...

The excel table (with same letters corresponding to matching data) looks like:
a1 w1 g1 x1 y1 b1 z1 e1
a2 w2 g2 x2 y2 b2 z2 e2

What I'd like to be able to do is copy the web table to my clipboard and paste just the corresponding data into excel (so A1=>a1, B1=>b1, E1=>e1).

Although I'd like to use the clipboard, I'm open to other suggestions. Thanks for the help.