I have a table full of historical data which is updated week by week. I want
to have another table that only shows the last 5 weeks worth of data and
updates automatically each time the historical table is updated. Is this
possible (or partially possible) in excel? If so, how do I go about doing it?

Many thanks