Autopopulating data from master Excel to new Excel

Hello All,

I am stuck with a problem and would appreciate if someone can help me. Here my question.

I have a master sheet where column A, B, C etc. resides username, password, application etc. information.

Now I have created a report which has questions in 1st column of new excel sheet where row 1 will have question 1 - what is username ?, row 2 - question 2- What is the password ?. Row 3 - question 3 - What is the application etc.

My task is to populate answers from master sheet to each individual questions.

Example:
COLUMN 1. COLUMN 2
ROW 1 What is the username - Roy
ROW 2 what is the password - p1234
ROW 3 what is the application - SAP

This information is populated from master sheet. I have 300 usernames passwords and applications in master sheet and I need to create 300 individual reports with VBA so it automatically does for me. How can I do it ?

Appreciate all your help in advance. Thank You !!