Data entry using forms

Hey people of the internet!

I had a query and I hope you guys could help me out.
Basically I had two different workbooks with a table each and they both have 3 common headings (as in the heading in the columns are same). And four (2+2) other columns that are different from each other.

Now basically, I have to update these tables with relevant data on a weekly basis. I wanted to know if it's possible to have a common form where i can just input all the details at once and it gets added to both the workbooks under the relevant headings.

Right now what happens is I've to fill both the sheets separately.

Any other alternative way to make this menial work easier for me, is much appreciated!