I am consolidating statements being received many branches, with simple copy
& paste special (values). Any macro-code for jumping to the last empty row
and pasting the data being selected and copied from the other sheet.

Example:
A.xls (MAIN);
B.xls (BRANCH REPORT);
Both reports opened;
Data selected from B.xls and copied Ctrl+C;
Switched back to A.xls;

RUN MACRO

Data pasted on excel to the last empty Cell A1 and onwards, in Paste Special
(Values) mode.

All the help as per your expertise shall be highly obliged.

Thankfully,

FARAZ!