When you say "Name" columns do you mean a Range or a column with "Name" as the first row element?? If the latter is the case, your query might fail. You should specify the cell range next to the sheet name. Also the double quote around Sheet1$ should be padded.
INSERT INTO [""Sheet1$""](Name) VALUES('John');