The 21-year-old passed away after being involved in a road traffic accident on the M1 while travelling back from a match at Bedford Town.
Police are now appealing for anyone with information or dashcam footage to contact them as more intelligence is needed on how the incident occurred.
Macclesfield posted a sentimental tribute to their player in an official statement, as the club paid their respects.
“Ethan was an incredibly talented and well-respected member of our First Team Squad, who had his whole life ahead of him,' the club said.
“But more than that, Ethan’s infectious personality endeared him to everyone that he came into contact with.
“In giving his all in everything he did, Ethan effortlessly pushed us all to be the best we can be – both on and off the pitch.
“Ethan’s professionalism and unwavering work ethic inspired everyone, and his lust for life put smiles on all our faces – even on the darkest of days.”
McLeod joined Macclesfield on a free transfer last summer, making three league appearances this season. The team won 2-1 at Bedford on Tuesday night before travelling back.