creating a database from mutiple source files

i have been on this for a while now and i dont know how to do this
i have to create a database of the forms that are filled in. the forms are all of the same format.
now i have a database file which is like the one that i have attached.
And i have the form sample attached as well
what i want is that if i fill this "HCP form 1", all the entries will automatically be filled in the database under the relevant column headers.
this is just one form, i have tens of thousands of such HCP forms. Is there a possible way that as soon as a fill out the forms (however many they are), the database starts to populate with data under relevant column
much help will be appreciated. Thank you

AttachmentSize
Database.xlsx8.23 KB
HCP Form 1.xls35 KB