how to make a dynamic workbook?
 

i have an excel sheet which has some monthly raw data, which is the
basis of calculations on the rest of the worksheets in the workbook. i
created links by doing a paste special.

what i want is, that when i replace data in the raw data sheet every
month, it should automatically update the rest of the worksheets. the
structure of the new data will be same throughout, just that the
number of rows will change time to time.

In short, i want to know how to make a dynamic workbook, which
populates itself when any modifications are made to the raw data
worksheet. Is it possible to do that? Do i need to incorporate some
kind of a VB script for that?