Combine random cells from numerous sheets and documents

[mtn]

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.

[AMoreno]

Go Advanced (bottom of thread)
Additional Options Box (bottom of post reply box)
Attachments, click manage attachments
Upload from computer or wherever, click Upload
Close window,
Then Submit Reply

[mtn]

Go Advanced (bottom of thread)
Additional Options Box (bottom of post reply box)
Attachments, click manage attachments
Upload from computer or wherever, click Upload
Close window,
Then Submit Reply

Yeah, the dropdown isn't showing for me. Will try a different computer. Thanks!