Can somebody tell me how to get through this?? Like I've tried "sed" as well as "jq" to modify the exported file to change the format from org/project/stack-name to Stack only but it didn't worked.

Your stack references have to be

organization/$PROJECT/$STACK

(and they only work for states stored in the same

.pulumi

path in the same S3 bucket)