In answer to your question
Quote 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