Auto updating sheets

Hi. I would just like to ask is it possible to do this on excel. Let us say I have a sheet named 'Master List'. then I have multiple other sheets named after departments such as 'Finance', 'IT', etc. All of these sheets have the same columns. What I want is that when I input a new row on the department sheets, the Master List sheet will automatically populate too based on the data I input on the department sheets.

Is this possible? Thank you very much.

In answer to your question

Originally Posted by CharmedChancer

Hi. I would just like to ask is it possible to do this on excel

Yes!

If you would like some suggestions how please post a sample workbook so that posters here can get a good picture of what you are trying to achieve, in your sample try to show the master sheet as you would like it to look i.e what data from where?, be descriptive in the workbook to aid anyone who wants to help you with this problem.

Regards,
Simon

P.S Please change the title of your thread to one that reflects the content as the one you have supplied does not imply what you require as per the Rules