Pull data from multiple worksheets into one

Disclaimer: I know there's technical jargon for everything I'm about to say however this is the best way I now to communicate..please don't judge! I currently have a macro-enabled workbook that does the following: 1) I enter data on Sheet 1, for example 5 rows showing apt.#, name, MI date. Then, I click a button that asks 'how many copies?' For this example, I'll say 5. This makes 5 copies of a different sheet (Sheet 2), each labeled according to the data within each row on Sheet 1. For example, '1. #2B Chase', '2. #3B Thomas', and so on. Sheet 2 has drop-down fields; I choose data within a drop-down in one field, then the next field is a drop-down based on the prior field. I need the data entered on each copied form to pull onto a different sheet (Sheet 3). So ultimately, Sheet 3 is a report that shows all the data I entered onto the Sheet 2 copies. How do I do that?