ExcelBanter - How can I get excel to load data from a multiple sheet displaying

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I get excel to load data from a multiple sheet displaying (https://www.excelbanter.com/excel-discussion-misc-queries/222483-how-can-i-get-excel-load-data-multiple-sheet-displaying.html)

petes89

How can I get excel to load data from a multiple sheet displaying

I have in excel a number of sheets (covering year on year) I want to display
certain data from these sheets over a six month period so when a new month
starts the month six months ago is automtically dropped--
petes89

All times are GMT +1. The time now is 06:54 PM.