I have 3 Excell Workbooks, i need to create a master sheet, but when ever i update the master sheet the data updated shouls reflect in all the workbooks.
you can try to create a Master sheet using a common column that is found in all the 3 spreadsheets
(just like setting a primary key under access)
To sort or modify items you can use thePivot Table(s) option ,modifications made in the any of the spreadsheets will be only reflected in master sheet (once you refresh the page).