I have a bunch of submissions that are all using the same template. I don't own this template and cannot make changes within it, as much of it is protected--however, I can copy and paste in it.

I would like to take the submissions, throw them into one folder, and somehow run... something... to pull all of the submissions into one sheet.

I've attached what I want, but pretend that we have 30 different submission files. Everything in yellow is something that we'll need.

Is it possible to do what I want?

Thanks,
mtn

EDIT: Attachment not working. Trying to fix that.