I have a master spreadsheet with all my information on it which requires me
to add 6-7 columns everytime i need to input data for a new date. This new
data is entered between other cells, and is broken up into sub categories.

These sub categories correspond to a respective seperate spreadsheet in the
same workbook.

My objective is to create a formula for each sepereate spreadsheet linking
to the "master" spreadsheet so that i can input the data in the master
spreadsheet and have the other spreadsheets update themselves (by creating a
new column when i create a new column in the master spreadsheet and inputting
the data i input in the master spreadsheet)
yes this is like creating a entire program to do this, but I can see Excel
being capable of doing this.
It would save me hours of work!

Thanks