Obtain text between words and populate to different cell in another sheet

[dumplingmast]

Hi there,
Trying to write some VBA to populate a few cells from another sheet.
Sheet 1:

Sheet 2:

In Sheet 1, cell D2, the code should look for 'Application Name:' field on Sheet 2 (merged cell A4) and return 'Task Management' (merged cell F4).
In Sheet 1, cell E2, the code should look for 'System Name:' in merged cell A2 on Sheet 2 and return 'Sandbox'.
In Sheet 1, cell F2, the code should look for 'Version:' in merged cell A2 on Sheet 2 and return '6.4.00100.1056'.
In Sheet 1, cell G2, the code should look return '1/31/2019' in merged cell A3 on Sheet 2.
If possible, there are multiple sheets like Sheet 2 in the workbook, and need to loop to bring those values to Sheet 1. Any assistance is greatly appreciated.

[dumplingmast]

Sorry...just realized the Sheet 1 and 2 images does not display. Here they are -

Sheet 1:
Sheet1.png

Sheet 2:
Sheet2.jpg