Name of Workbook, & howm many Number of Row Copied write on Cell

Registration date
Tuesday September 27, 2016
Last seen
September 27, 2016
Hi all,

Can anyone please help me below i have added three more column H ,I and J In H Column i would like to give Workbook name which i want to copy particular sheet in H column i would like to print the sheet name from where data copied and in J column i would like to print how many rows are copied from that particular sheet .
Can anyone help me please i need this one