Refreshing Window In Order
There is an Excel file that teaches how to perform the Refreshing Window In Order operation.
Excel Professional Refreshing Window in Order
This workbook demonstrates refreshing window in order using VBA macros on a 29-row data layout.
Hope it is useful.