Hey @Jino, If you are talking about the different sources being ssh enabled host then they can be DynamoDB, Amazon-EC2 or EMR. You can use the COPY command to load/ copy data from Redshift to any of the following.
You can also use AWS Data pipeline and specify the source and destination.
The above two will serve the purpose.
Hope this helps!