First line missing in auto filter to multiple sheets

Hi,

Sample attached exactly represents original file so cell references to remain as is.
All data is for sample reasons only except column 'I', this is exact.

The Macro "sort" when run sorts all data on Report sheet in to all other sheets dependant on number in column 'I'

For sake of ease there is a Macro "clearsheets" that will clear sheets 1-17 but leave data in Report sheet so you can test your code

Issue I have is when Macro "sort" is run, it sorts all data from report sheet but misses out row 6
So in sheet 1 you will see row 6&7
All other sheets you will see rows 6-8

But in report sheet you will see there should be 3 entries for sheets 1

I have a feeling this is something to do with the autofilter being addressed to the first row I am trying to sort but I am unsure how to fix it

Hope that all makes sense and thanks in advance for you help