Linking Entered Data to "Master"

Occasional Visitor

Hi! I'm working on a project for my internship and am in over my head. My task is to collect data entered onto a template into a sort of master data log. A little more info: I work in healthcare, and for each patient we rename a template sheet and enter their specific test results (about 1500 cells). I need to figure out a way to collect that data into another mega data sheet. Advice?