Pull data from multiple worksheets into one

Not sure if i chose the correct forum for this issue - feel free to guide me to the correct one if applicable.

Here's my scenario:

Within my workbook are 3 worksheets. 1st called 'Exit Interview', 2nd called 'Rent Roll' and the 3rd called 'File Review Form'. On rent roll, I enter specific information (i.e. Apt. #, Tenant Name, etc.). Total entries on this form can be up to 25. Once complete, I created a macro that copies the 'File Review Form' and creates one per entry on the rent roll. For example, I select a 'copy' button, i'm asked how many copies, I say 5 and 5 file review forms are created within the workbook. In addition, each file review form is renamed to match each entry (i.e. '1A, Crouse, FileRev', '2A, Chig, FileRev' and so on.)

Here's my question:
Each file review form has finding notes. I want to pull the finding notes from all created file review forms into the 'Exit Interview' worksheet. I was able to figure out how to do that from one form, however it's not working from the copied forms. Maybe it's because the name of the worksheet changes from 'File Review Form' to 'Apt #, Tenant Name, FileRev' and it cannot pull the new data?

Any advise is appreciated.