Need a VBA script which fetches data from JIRA API according to user entered issues

Job ID: 32303068

Budget: €30 – €250 EUR

The process would be:

1) enter the jira URL automatically
2) sign in using user entered username and password automatically
3) The excel sheet would have cells in a column form filled with issues manually entered by user. The program would have to get the details for each issue where I need ALL details (status, project, summary, creation date, update date, assignee, etc.) in table form. Also need a way to have them updated on command