Copy Paste Values On last Used Row in Formatted Table

[gauravkrgautam]

Hi All,
Good Morning All My Seniors (IST)

I am working on two macro based file where one is team performance (Source File) and other is Day-On-Day Database (Destination File). Destination file contains table with few columns with some formula (Column F). Now challenge is that source file has two table one under another on may be single table depends on days & both tables are dynamic may contains more data or less data and table in destination file has table which creating confusion for last row. to be updated with copy paste value.

i want to copy-paste-value from source file ("C6:E9","F6:G9","C13:E16",F13:G16")

Sample files are attached, i hope that will(Source workbook) clear the whole requirement.

Thanks in Advance

 

[gauravkrgautam]

Is above problem is too much easy or too much difficult that is not anwered,
pls help me