dividing table historical data

ezzathesham 

Is it possible? Yes.

Is it a good idea? Maybe yes, more likely No.

Back up a bit here and tell us why you are thinking you might want to take a perfectly good table of data, data that spans 20 years, and break it apart.

Excel is very capable of doing analyses, parsing 20 years' worth of annual data on a given stock, or index, from a single database. (Other things as well; I just mention those since you describe it in passing as stock data.) Breaking it into 20 sheets might well be what we'd do if we were doing the analysis manually, on paper ledger sheets, but in many instances taking that mental paradigm and implementing it in the Excel environment would be interfering with some of the amazing capabilities of Excel (of computers in general).