Loop through data validation list, copy and paste a range

Hi there

Hope you can help, please. I have browsed the forum but somehow the solutions, although it looks appropriate, do not solve my problem.

I have a list of 49 items in range A5 to A53 and they are linked to a data validation cell B2.

Every time I change cell B2 range G4:K2020 is updated (looks up values and does calculations from other sheets).

I want to loop through the data validation list and every time copy the output (G4:K2020) and paste special values in another sheet below each other for each items in that validation list.

Your help will be greatly appreciated.

Thanks a lot!