Fetching of data from number of other sheets to a master sheet


respected consultant,
I have created a Excel Sheet for student class attendance. in it i have made a provision for over all attendance of a student in percentage. now i want to combine sheets of each and eveary subject in a single workbook. also i want to determine the percentage of attendance of a student in all subjects combinely. in this regard i need to provide a link on master sheet to automatically fetch/copy cells/coloumn from number of other sheets. can it be done. Please help.
Thank You