Need VBA Code to Delete One particular sheet and clear data in 6 sheet

Hi experts

I have set of data which is stored in path location as excel file AMP_aus.xlsx ,i want delete the one particular sheet and clear range of another 6 sheet

RAWDATA should be deleted.

Remove Range A2:BG Leave First header row A1:BG1.
These 6 sheet range should be clear
ACOMMS
AUSTRAC
AML
ACT_AUS
AUS_NZ_SQUAD
CTF

file stored at C:\Users\Windows 10\Desktop\AMP_aus.xlsx

find the attachment