you can define the PartsList name with this function (in
insert/name/define...):
=OFFSET(Sheet1!$A$1;0;0;COUNTA(Sheet2!$A:$A);1)
and it will automaticaly change its size depending on how many items
there are in the A column