VBA and sharepoint

Have a spreadsheet that has information that is needed for our sharepoint site. I have figured out how to open the sharepoint site when the user clicks submit but I am having a difficult time importing cell information into sharepoint. For example on the the sharepoint for the title should come from Sheet1A2 and so one. Thanks