Macro for adding a new line of refeneced data from new worksheets

[twday]

I've been searching for ways to do this for a while now but haven't been able to find anything that works yet.

The Workbook in question is a Sales Ledger with a Current Sales worksheet and a separate worksheet for each sale.
The Currents Sales worksheet references data on each sale worksheet so that it will update whenever the individual sales worksheets are changed.
What I would like to be able to do is to create a macro that will automatically put all the needed data from a new sale worksheet in the first blank row if the Current Sales worksheet.
Any help is greatly appreciated! If you need more information let me know.
Thanks in advance.


Current Sales Worksheet:
Excel 2012

	A	B	C	D	E	F	G	H	I	J	K
1	Contract #	Forest	Buyer	Acres	Timber Type	Status	Payment Due	Expiration Date	Inspection Date	% Harvested	NOS Link
2	X009516	Cortland 6	Not Bid Yet	23	SWD	NBY	10/2/2014	10/2/2017	#NUM!	0%	y
3

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Current Sales​

Worksheet Formulas Cell Formula B2 ='X009516'!$B$1 C2 ='X009516'!$C$9 D2 ='X009516'!$B$3 E2 ='X009516'!$G$3 F2 ='X009516'!$D$53 G2 =IF('X009516'!H$18="N",'X009516'!C$18,IF('X009516'!H$20="N",'X009516'!C$20,IF('X009516'!H$22="N",'X009516'!C$22,IF('X009516'!H$24="N",'X009516'!C$24,IF('X009516'!H$26="N",'X009516'!C$26,"PIF"))))) H2 ='X009516'!$C$12 I2 =LARGE('X009516'!A$55:A425,1) J2 =LARGE('X009516'!E$55:E$169,1) K2 ='X009516'!$K$1 <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Sale worksheet:
Excel 2012

	A	B	C	D	E	F	G	H	J	K	L	M	N	O	P
1	State Forest	Cortland 6				Contract #	X009516		Linked	y
2	Stand #'s	I-29
3	Acreage	23				Sale Type	SWD
4
5	Bid Date	10/2/2014
6	Minimum Bid		$6,085.00		Bid Amount
7	Bond Amount				Amount Returned
8
9	Buyers Name		Not Bid Yet
10	Sub-Contractor??
11
12	Expiration Date		10/2/2017
13
14	Payment Schedule
15
16	Item	%	Date Due	Adj. Date		Amount		Payment Made (y/n)
17
18	Bid Deposit	5%	10/2/2014			$0.00		n
19
20	1st Payment	20%				$0.00		n
21
22	Lot A	40%	7/1/2015			$0.00		n
23
24	Lot B	35%	1/1/2016			$0.00		n
25
26		0%				$0.00
27
28		0%				$0.00
29
30
31	Insurance Certificates
32	Type		Expiration Date		Exemption #
33	Liability
34	WC Insurance
35
36	Logger Cerification #'s
37
38	Name			Cert. #		Expiration
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53	Sale Diary		Status	NBY
54
55	Date		Inspector		% Harvested		Comments
56					0%

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

X009516​