An Azure service for ingesting, preparing, and transforming data at scale.
You can make use of For each activity and copy activity to copy multiple tables in bulk. Else other option is create separate 6 copy activities and copy 6 tables data
For reference:
https://www.youtube.com/watch?v=KsO2FHQdILs
https://learn.microsoft.com/en-us/azure/data-factory/tutorial-bulk-copy-portal
----------
Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav