@Narayan Which MacBook model and OS version were you using?
As mentioned, there might be one or a number of points of failure, so I would start with the SD card and then move along the file transfer timeline.
Because you used the SD card after encountering the problem, chances are that some or all of the files that you would like to recover have been partially or fully overwritten to the point where recovery isn’t easy. So, you would still benefit from checking the files on the MacBook and then on the workstation.
Again, it would be wise to create an image of those files or folders on a separate disk, so that when you examine them you wouldn’t risk further hardware, software or firmware failure.