I HAVE 12 SHEETS AND 1 MASTER SHEET IN A FILE. IN MASTER SHEET I WANT THE DATA OF DESIRED ONE SHEET EITHER OF 12 WITH REFERENCE GIVEN IN A CELL. e.g. sheet names are 1 to 12 and in master sheet i want to pick the data of sheet1 with a single reference given in master sheet.
Plz help me in feeding a formula from which i can be able to make a global reference with multiple sheets e.g. I have Tweleve sheets with some data and A master sheet in which i want to give a referenceof sheet name( like sheet1) from which the date can be filled from desired sheet.