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.