I think you meant to include the content of @ArticleN in your string, rather than the name:
Change:
where
Manufactured_In=case when @ArticleN is null then Manufactured_In
else @ArticleN
end
Order by ' + @Sort
To:
where
Manufactured_In=case when ' + @ArticleN + ' is null then Manufactured_In
else ' + @ArticleN + '
end
Order by ' + @Sort