How can i create a area specific Macro?

I have a complicated workbook with many sheets. The way that each sheet is organized makes it so that each sheet has around 20 different 8x25-cell tables alighned vertically down the sheet. To the right of each table is it's corresponding data area that is specific to the topic of the sheet. My end goal is to fulfill each data table within the sheet by pulling that tables specific data from it's (corresponding) area of the sheet. To clarify, there are 20 unique data areas that correspond with each one of the 20 tables (empty table 1 has a corresponding 'data area' that table 1 will pull its data from). The reason i need to pull the data into the tables is to organize the data in a fashion that allows for calculations to take place.

Is it possible to create a macro that pulls (1 table at a time) the data from the corresponding data area into the formatt of the empy tables (pull data for table 1 from data area 1)? In other words, can a macro be created based on pulling the data from 'data area 1' to 'table 1', then oriented the macro for reuse on the remainder of the data area's and their corresponding tables?

For example: Create a macro based on table 1 pulling data from data area 1. Then reuse that macro for tables 2-20 by pulling table 2's data from data area 2, and table 3's data from data set 3, etc...

Any assistance is apprectated.
Thank you, i apreciate any help.

Formatting Example.xls

Here is a formatting example.

Thank you.