Hi - first post here and hoping someone can help.

I've got a question that might be simple but Im not overly experienced with Excel.

I have a Master spreadsheet which is used as a source for three additional worksheets. Eg The master shows data for three areas (North, South East and South West and then each of the areas has its own worksheet showing only its own data)

The three smaller worksheets pull data from the source sheet as it is the one where the data was inputted.

What i have noticed is that if I insert a row or column to add more data on the source page, it is not reflected in the three additional worksheets.

Is there anyway to achieve this so I don't have to update multiple sheets but can just update the source sheet and the other sheets will be automatically updated to reflect this???