Pull data from one Excel sheet to another automatically - without using vlookup or index,match,validation functions –
Only with simple VBA codes.When you enter values of Id in the "GetData page's A column", you can get Id's row information from the "Data" page .