I have a sheet that is used with different data every week, after doing a 'master' pivot of all the data I then need to split the data down into three, filtered by time range (05:30 - 13:29, 13:30 - 21:29 & 21:30 - 05:30). I currently do this by manually filtering the master data then copy/paste into a separate sheet to create the pivot for each time period. Is there a way I can set up three pivots tables that each display the data for each respective time range?

Thanks.