Importing images into collection or media rotated

Hi folks!

Hate to start up a thread seen on a prior topic, but I’m running into this issue which is a bit more daunting.

I have photos taken by photographers on both Nikons and Canons, and for a significant number of them when I drag them into the media section OR into a collection field, they’re being rotated. I see from older posts this was an issue with mobile device images, but nothing about DSLR shots. If this was a case of a few images I’d be fine opening them and resaving, but I have hundreds of images.

Any advice and feedback would be greatly appreciated!

Here is my public share link: LINK
(how to access public share link)