I'm brand new to VBA and macro's and learning more by the day. I have been asked to develop a spreadsheet for work that will keep track of projects as they progress through our shop. This spreadsheet needs to gather data from another spreadsheet on our server to populate a worksheet with in the workbook I'm building.

Here is the idea:
Worker enters job number into form (spreadsheet based), and due date
Spreadsheet would pull data off of a spreadsheet on our server and populate an "information sheet", located within the workbook that contains the sheet on line one, and the user and others with in the system would be able to see the information sheet.

I have page one built and have a hyperlink to a temporary spreadsheet for population of the information sheet. The question is "how do I automatically populate the "information sheet"?