The marco runs but pastes the data into all seven sheets rather then just the specfic sheet required

Thanks for the help so far