Transfering Cells Values from one Workbook worksheet to another workbook worksheet. Provided all the relevent fields are there

[guhaseelan]

[TABLE="width: 1349"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Week Ending :
[/TD]
[TD="colspan: 3"]Friday 20 Oct 2017
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] Supplier
[/TD]
[TD][/TD]
[TD]1515
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Purchase Order
[/TD]
[TD][/TD]
[TD]2626
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date
[/TD]
[TD]Detail / Course
[/TD]
[TD]TrainingParent
[/TD]
[TD]Sub
[/TD]
[TD]Ground Sch / Device Time
[/TD]
[TD]Training Venue
[/TD]
[TD]Further Info
[/TD]
[TD]Hours
[/TD]
[TD]rate (£)
[/TD]
[TD]cost (£)
[/TD]
[TD]GL Code
[/TD]
[/TR]
[TR]
[TD="align: right"]15 Oct 2017
[/TD]
[TD][/TD]
[TD]Instructor
[/TD]
[TD][/TD]
[TD]GroundSch
[/TD]
[TD]Stains
[/TD]
[TD][/TD]
[TD="align: right"]4
[/TD]
[TD][/TD]
[TD] £ -
[/TD]
[TD]21040003 200 201
[/TD]
[/TR]
[TR]
[TD="align: right"]16 Oct 2017
[/TD]
[TD][/TD]
[TD]Command Course
[/TD]
[TD]30
[/TD]
[TD]GroundSch
[/TD]
[TD]Kingston
[/TD]
[TD][/TD]
[TD="align: right"]6
[/TD]
[TD][/TD]
[TD] £ -
[/TD]
[TD]21040003 200 201
[/TD]
[/TR]
[TR]
[TD="align: right"]17 Oct 2017
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD][/TD]
[TD] £ -
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Hi some urgent help on a sheet that I am working on. Above is a sample of the sheet that suppliers fill in for the hours done. There will be multiple suppliers and these data have to be transferred to a master sheet.

What I need is a button linked to a macro on this sheet that when clicked. Will transfer the fields highlighted in bold and underlined.

The "supplier" number and "purchase order" will be the first two fields in this master sheet and are in cells J8 and J9.
Then for the actual table if there is a GL code in cell L12 then row information can be transferred (so an if function). The first information to be transferred will need to be the date (cell b12) then the hours (in cell i12). Then the actual GL code (columnL12). Remember (sorry) for these info to be transferred only if the GL code is present.


There will be multiple supplier sheet so eveytime the button is clicked the master sheet needs to be populated so finding the free row at the bottom of the master sheet is very important.


Hope this makes sense. I can figure things out but just need an outshell of VBA code. Also when the button is pressed would be good for the master sheet to be opened. This will be names the Saturday of the week.

thanks you in advance
!