Seeking Help - Importing Data from Multiple Worksheets and Maintaining Style

Hello!

I am trying to assemble a master task list which is composed of other, smaller task lists. I would like the master task list to update when I edit values on the individual worksheets - Ideally vice versa, but I am starting small due to my limited experience with Excel's stronger tools.

I have attempted to use the get data function to draw gather data from a single worksheet, however, the formatting is not consistent to the source or destination - So too it does not adopt the master sheet's headers. I need to have the Pivot functionalities in the master book, and so too I need to import data (With the same column values) from other workbooks without rows overlapping or missing - Ideally, I need them to be smart enough to shape around each other.

Hopefully this is not extremely beyond my depth - I have watched a few tutorials on the necessary commands and functions, but they are oriented towards numeric data for visualization purposes - I'm just trying to keep track of all the things I'm doing, across nearly forty separate and unique workbooks all working with the same data types.

Any assistance would be greatly appreciated. This is my first time diving past formatting, hyperlinks, and basic functions and it has actually been rather thrilling.

Cheers!

Thanks!

I am dealing with multiple workbooks. To illustrate, I have a workbook labeled "TaskList_Personal" that I wish to have act as a summary of individual personal task lists (i.e TaskList_Social, TaskList_Medical, TaskList_Discordianism, etc.). I initially managed the data in one large workbook but found that to be clunky at a certain point, so I broke them all out as individual workbooks. I have a backup of that file, but I am hoping that I can find a means to make this approach work.