copy text from webpage then paste into excel

[X82]

I complicated situation this one, but I will try to explain it best I can.
At work, we needs to access the powerbars for servers to find out ampage. In short, we have to go an an ip like 174.45.71.4 for each powerbar. And we have 1000. We take the amps reading and place it in an excel spreadsheed for that IP and that day. This has to be repeated for the other 999 powerbars 5 days a week. A tiresome task.

Does anyone know a way of taking a certain peice of text from a website, in this case the amps reading and pasting it inside excel? So I can automate this task best I can. At the moment, it's tedious.

Thanks in advance.

 

[X82]

Thanks for the replies.
I will say that when it comes to programming I know nothing.
The site I need to access requires a log in and password, which is all the same throughout the 1000 pages by the way. Don't know if that complicates things.

From a programming newbie perspective, how would I start programming this task in VB? I only have access to firefox (which the powerbars only work in, not IE) and office 2010 at work. I have no ability to install extra 3rd party programmes.

Thanks again.